Use IS DISTINCT FROM for NULL-safe comparisons in SQL Server 2022, understand older workarounds, and inspect index seeks before changing code.
GREATEST, LEAST and Other Small Helpers
GREATEST, LEAST, and recent T-SQL helpers replace bulky CASE patterns while preserving explicit rules for NULL and data types.
Three-Valued Logic: TRUE, FALSE and UNKNOWN in a WHERE Clause
Understand three-valued logic in WHERE and CHECK, avoid NULL-poisoned NOT IN, and use SQL Server 2022 null-safe comparisons.
CONCAT_NULL_YIELDS_NULL and CONCAT: How NULL Behaves in Strings
The CONCAT_NULL_YIELDS_NULL setting decides whether a string plus NULL returns NULL. The CONCAT function never looks at it and treats NULL as an empty string. This post tests both on a customer table, shows the errors the OFF setting causes, and gives safe patterns for names and numbers.
CASE Expression Pitfalls: NULL Tests and Data Type Precedence
Reproduce CASE expression traps with NULL tests, mixed result types, missing ELSE, and nesting, then apply clear rewrites.
Where T-SQL Differs From the ANSI Standard
See where T-SQL differs from the ANSI standard in row limits, concatenation, NULL behavior, and practical query portability.
SQL SERVER – SSMS Does NOT Print NULL Values
Here is a very interesting question asked on the blog by Karthik. I really liked the question and I would like to discuss this here about SSMS doe snot Print NULL values.