How to Find Missing Values in a Sequence With SQL

SQL Server 2000 Date and Time Puzzler

How to Analyze Statistics From SQL Query Analyzer

RAISERROR Severity Levels Demystified

A Bug in Microsoft SQL Server’s Replace() Function

Efficient Alternatives to Microsoft SQL Server’s Openxml

How to Understand SQL Joins

How to Group Data in SQL With a Catch-All Bucket

How to Simulate the GROUP_CONCAT Function

Singular vs. Plural Table Names

How to Simulate the SQL ROW_NUMBER Function

The Difference Between Subqueries and Derived Tables in SQL

How to Write INSERT if NOT EXISTS Queries in Standard SQL

How to Write a SQL Exclusion Join

How to Write a UNION in SQL Without Using UNION

Mutex Tables in SQL

How to Write Subqueries Without Using Subqueries in SQL