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