Faking Arrays in Transact SQL

It is a simple routine that we all need to use occasionally; parsing a delimited list of strings in TSQL. In a perfect relational world, it isn't necessary, but real-world data often comes in a form that requires one of the surprising variety of routines that Anith Sen describes, along with sage advice about their use.

Accessing and changing data 2008

Yet Another Pad Utility

A useful user defined function for padding values from the left or right with any token, number, or character.

ANSI PADDING, Trailing Whitespace, and Variable Character Columns

What does ANSI_PADDING mean and how does it affect my SQL Server database?

What is the result ? (SQLServer 2005)

Union

One of the less used commands in T-SQL, the UNION command can come in very handy in a number of situations. SQL Server expert trainer, Andy Warren, discusses how you can use UNION.

Type lengths

generate save, delete, get, and list objects for a table

crates sp and function template for a table

Best Practice

Two methods for converting T-SQL date/time values

Learn two built-in functions for SQL Server data conversion from T-SQL date/time values to character types. These methods include SQL Server CAST and CONVERT.