Formatting Specfics Database Objects Quote all database objects/fields using square brackets Reference all objects by owner/schema Eg: [dbo] . [authors] Keywords Use UPPERCASE for all keywords Eg. SELECT * FROM [dbo...

Basic Formatting and Indentation Use 4 spaces for indenting Use 4 spaces for indenting in your database source files and remain consistent throughout the file on the number of space chosen for an indent. Editors will allow you to configure the...

Database Object Naming Rules Summary: Casing Prefix Suffix Alpha Numeric Characters Notes Tables Pascal x Use singular form: Eg User, not Users Linking Tables...

General Naming Convention Rules Definitions: PascalCasing – The first character of each word is capitalized. Example: F irst N ame camelCasing - The first character of each word is capitalized except the first one Example: first N ame UPPERCASE...

In this sample includes enhancements to FOR XML in SQL 2005...