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.

FORMATMESSAGE

LIKE operator

Rowversion

VarChar(max)?!?