Best Practices for Coding SQL Statements by James Seymour
Approx. 2,760 words.
Published on July 26, 2012.
The purpose of this document is to convey best practices for coding SQL statements. While there are dialects of SQL among the various database management system vendors, including many variations and extensions, this document will deal only with general conventions that apply to the SQL use within Microsoft, Oracle, and IBM DB2.