Best practice For T-Sql Syntax

Question

Are there any books or articles that discuss best practices for T-Sql syntax and proper T-Sql commenting.

I'm looking for soemthing to help me syntax and commenting within the T-Sql code.

Right now I use StyleCop and Resharper for C#/VS2010 but I don't know of anything for Sql.

---

chuckdawit

Answer 1

Hi,

here are two articles which discuss best practices:

• http://www.sql-server-performance.com/2001/sql-best-practices/
• http://www.databasejournal.com/features/mssql/article.php/3827091/T-SQL-Best-Practices.htm

---

Best Regards. Please Mark Answered, If my solution solves your problem.

Answer 2

The following page has helpful links to articles on the given subject:

http://sqlusa.com/sqlformat/

It also has a link to a free, online sql code formatter (beautifier).

Most of the SQL code is self-documenting. It only requires documentation on anything which are not obvious to a (different) database developer.

Example for stored procedure header comment:

http://www.sqlusa.com/bestpractices/stored-procedure-documentation/

---

Kalman Toth SQL SERVER 2012 & BI TRAINING
New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012