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.


Code to strip all special characters from text.


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.