Monday, February 06, 2012 5:26 PM
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.
Monday, February 06, 2012 5:37 PM
here are two articles which discuss best practices:
Best Regards. Please Mark Answered, If my solution solves your problem.
- Proposed As Answer by Naomi NMicrosoft Community Contributor Monday, February 06, 2012 7:11 PM
Monday, February 06, 2012 7:09 PM
The following page has helpful links to articles on the given subject:
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: