SQL Server CASE Law

SQLs CASE expressions can be powerful magic, but can trap the unwary that are used to the more familiar CASE statements of procedural languages.

LOB Data

The EXCEPT and INTERSECT Operators in SQL Server

The UNION, EXCEPT and INTERSECT operators of SQL enable you to combine more than one SELECT statement to form a single result set. Rob Sheldon explains all, with plenty of examples.

Displaying Sorted Hierarchies (SQL Spackle)

Learn how you can query a hierarchy of data and also return the results in an ordered fashion. A handy T-SQL skill that you will use over and over again.

ROWGUIDCOL

The Percent Sign in T-SQL

Top 10 Transact-SQL Statements a SQL Server DBA Should Know

Microsoft SQL Server is a feature rich database management system product, with an enormous number of T-SQL commands. With each feature supporting its own list of commands, it can be difficult to remember them all. MAK shares his top 10 T-SQL statements that a DBA should know.

Keywords

Automatically Generate Stored Procedures

This article will show you how to automatically generate insert, update, and delete procedures for tables in your database

Custom Sequence Numbering

This article shows how to implement low cost custom sequence numbering logic via a cunning use of the the ROW_NUMBER() function