SQL 2005

SQL 2005 - Coding Standards - Formatting Specfics

Formatting Specfics Database Objects Quote all database objects/fields using square brackets...

Author: sbates 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...

Author: sbates 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...

Author: sbates 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...

Author: sbates Date: 03/19/2006

SQL 2005 - FOR XML enhancements

-------------------------------------SQL 2005 - FOR XML...

Author: sbates 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] =...

Author: sbates Date: 01/05/2006

XML Features - XQuery

------------------XML Datatype------------------/*The xml datatype can be queried using XQuery....

Author: sbates Date: 12/13/2005

XML Features - XQuery

------------------XML Datatype------------------/*The xml datatype can be queried using XQuery....

Author: sbates 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...

Author: sbates Date: 11/22/2005