Truncate rollback

Basic Defensive Database Programming Techniques

We can all recognize good-quality database code: It doesn't break with every change in the server's configuration, or on upgrade. It isn't affected by concurrent usage, or high workload. In an extract from his forthcoming book, Alex explains just how to go about producing resilient TSQL code that works, and carries on working.

SQL Server Ranking Functions

A new article from Wayne Sheffield that examines the ranking functions in SQL Server. Learn how you can use ROW_NUMBER(), NTILE(), RANK(), and DENSE_RANK() in your applications.

What is the value of SCOPE_IDENTITY()

Rowcount and multiple assignment

NULL

String length?

Column length

TSQL

Charpad - Character Padding Function

A generic character padding function. Useful for situations where you need fixed width formatting e.g. email reports.