Avoid Transact-SQL's Column Alias Limitations

A column alias seems like a great tool for referencing complex expressions, but SQL Server doesn't work that way. Learn a simple workaround.

More Conversion Fun

Polymorphed Proc

Conversion Fun

SQL Server 2005 Paging – The Holy Grail

Handling the paging of results in T-SQL has been a challenge for a long time. Robert Cary presents an interesting technique in this article.

T-SQL Functions

DateAdd Function

The Safe and Easy Way to Delete All Data in a SQL Server DB

Deleting all the data in a SQL Server database doesn't have to involve complex code. The undocumented stored procedure sp_MSForEachTable safely bypasses built-in limitations to accomplish this common task.

Identity Insert

Comparing Stored Procedures, Part 6

Sixth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures