hierarchyid IsDescendantOf tests membership in a subtree, including its root. These literal paths keep both compared nodes visible and distinguish self from a strict descendant.
CONCAT: Missing Inputs Produce Present Text
CONCAT builds display text from available inputs. Preserve missing-source flags when output alone cannot prove completeness.
WITHOUT_ARRAY_WRAPPER: Keep JSON Cardinality Explicit
WITHOUT_ARRAY_WRAPPER needs a single-row JSON contract. Compare one object with two unwrapped objects and validate the complete generated text.
geometry STIsEmpty: Empty Shapes Are Different From SQL NULL
geometry STIsEmpty tests whether an existing spatial instance has an empty point set. I keep that condition separate from SQL NULL. A missing database value and a present empty geometry are different inputs.
CURRENT_DATE, || and Other Small T-SQL Changes in SQL Server 2025
Use CURRENT_DATE, string concatenation, optional SUBSTRING length and bigint DATEADD in SQL Server 2025 with clear examples and checks.
Leap Years in T-SQL: February 29 and Date Math
Handle leap years in T-SQL with date functions, test February boundaries, and choose a clear anniversary rule for February 29 births.
COUNT OVER: Show the Filtered Total Beside Page Rows
COUNT OVER helps me keep a page’s row count separate from the filtered total. Compare full and partial pages. An empty page needs an explicit total-count contract.