XML nodes maps elements to rows. Extract values relative to each node, preserve duplicates, and review documents without matching children.
Finding the First Monday of Every Month in T-SQL
Calculate the first Monday without DATEFIRST, list a full year, find nth and last weekdays, and reuse the rules in an inline table function.
geometry STCrosses: Crossing Depends on the Intersection Dimension
geometry STCrosses uses the dimension and interior position of the intersection to define crossing. I compare it with endpoint contact and collinear overlap. A shared point or segment does not automatically satisfy that definition.
ISJSON Type Constraints: Validate the Top-Level Value
ISJSON type constraints distinguish JSON shapes. Compare VALUE and SCALAR, Boolean literals, JSON null and SQL NULL on SQL Server 2022.
datetime: Read Its Fractional-Second Rounding
datetime does not preserve every millisecond despite displaying three fractional digits. These typed conversions show its legacy rounding alongside the original datetime2 text.
JSON_ARRAY: Choose Whether NULL Elements Are Included
JSON_ARRAY constructs typed array text. Choose whether missing inputs disappear or remain JSON null placeholders before relying on positions.
XML value: Select One Typed Scalar
XML value extracts one typed scalar. Use a singleton path, review conversion, and distinguish first-item selection from uniqueness.