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

Counts Puzzle

Go go go?

Concatenating Row Values in Transact-SQL

It is an interesting problem in Transact SQL, for which there are a number of solutions and considerable debate. How do you go about producing a summary result in which a distinguishing column from each row in each particular category is listed in a 'aggregate' column? A simple, and intuitive way of displaying data is surprisingly difficult to achieve. Anith Sen gives a summary of different ways, and offers words of caution over the one you choose.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

An "old" subject is revisted where "newbies" can learn the methods and veteran users can get more performance out of the code.