SQL 2005
Formatting Specfics Database Objects Quote all database objects/fields using square brackets...
Date: 03/19/2006
Basic Formatting and Indentation Use 4 spaces for indenting Use 4 spaces for indenting in your...
Date: 03/19/2006
Database Object Naming Rules Summary: Casing Prefix Suffix Alpha Numeric Characters Notes Tables...
Date: 03/19/2006
General Naming Convention Rules Definitions: PascalCasing – The first character of each word is...
Date: 03/19/2006
-------------------------------------SQL 2005 - FOR XML...
Date: 03/02/2006
--Drop and createUSE [master];GOIF EXISTS(SELECT * FROM sys.databases WHERE [name] =...
Date: 01/05/2006
------------------XML Datatype------------------/*The xml datatype can be queried using XQuery....
Date: 12/13/2005
------------------XML Datatype------------------/*The xml datatype can be queried using XQuery....
Date: 12/13/2005
Well, I figure my first post should be an introduction, so here goes. I have been working as a...
Date: 11/22/2005