Automating Unique Auto-Increment Values in SQL Server Using Stored Procedures, Table-Valued Functions, and Common Table Expressions

Replacing NULL Values with Current Date in SQL Server Using Built-in Functions.

Calculating the Median of Aggregated Rows with SQL: A Practical Guide for Data Analysis