SQL Best Practices   

Following best practices in SQL can save you a lot of time and nerves. Here is the list of the most important points to follow:

• Always use ORDER BY in your SQL statement if the order of returned rows is important
• Avoid implicit conversions of columns and parameters in SQL statements
• Always include a column list in select and insert statements

---

JdbcFaq