Category: T-SQL Queries

Continuing his treatment of NULLs in SQL Server, Itzik Ben-Gan covers how SQL Server's implementation of unique constraints differs from the standard, and how you can work around it.

Itzik Ben-Gan discusses missing T-SQL features like the DISTINCT FROM predicate, the NULL treatment clause, and controlling how to order NULLs.

Itzik Ben-Gan continues his mind-bending series on NULL complexities in T-SQL, treating a variety of constructs including most people's nemesis, the MERGE statement.

Itzik Ben-Gan kicks off a new series of Transact-SQL blog posts treating NULL handling in SQL Server.