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.

TSQL variable