DataTamer: SQL Server Services

SQL Server Code

These code samples and snippets are written for SQL Server 2005 and 2008 with any version differences indicated in the body of the code.

Characters

Code to strip all special characters from text.

Datatypes

Code to list every column in a database with its datatype.

Date and Time

A few snippets for converting date and time data.

Management Trees

A simplified example of the creation of a management tree using CTEs.