GREATEST and LEAST compare several expressions within one row. These typed decimal examples show negative numbers, ties, partial NULLs and an entirely missing row.
SQL_VARIANT_PROPERTY: Inspect Decimal Precision and Scale
SQL_VARIANT_PROPERTY makes underlying types visible. Inspect explicit decimal widths, int, Unicode capacity and a missing variant value.
SQL SERVER – UDF – Function to Convert Text String to Title Case – Proper Case – Part 2
Part 2 on Proper Case in SQL Server: a quick script that makes only the first letter of a sentence upper case, and how to do it for a table column.
Stable Weekday Numbers Without Changing DATEFIRST
Stable weekday numbers use a fixed Monday anchor and negative-safe modulo. Map Monday to one without changing DATEFIRST or session language.
Splitting a URL Into Host, Path and Query String in T-SQL
Practice splitting a URL into host, path, and query values with T-SQL string functions, SQL Server 2025 regex, and ordered parameter rows.
ABS: Widen an Integer Before Taking Its Magnitude
ABS can overflow even when the negative input fits its signed integer type. I widen the input before asking for its magnitude. Casting the output afterward would be too late to protect the calculation.
SQL SERVER – 2008 – Get Current System Date Time
Several ways to get the current system date time in SQL Server 2008, from GETDATE to the newer functions, with a quick video on the topic.