T-SQL Language Changes in SQL Server 2022

SQL Server 2022 is in preview in August 2022. I assume this version will be released later this year, and I have been testing it with the idea that I will be looking at an upgrade sometime in the next year for a few servers. There are a lot of changes in the database platform, […]

EXCEPT Details

Understanding the Metadata Function DATABASEPROPERTYEX()

Learn how to use the DatabasePropertyEX() function to query your database for settings.

Operator Precedence

Schema Only Database Backup

Use DBCC CLONEDATABASE to make a Schema Only Database Backup

Using CONTINUE

INSERT EXEC statement cannot be nested, the Simple Solution

Step-by-step guide to solve the "INSERT EXEC cannot be nested" problem by using a CLR when unit testing stored procedures using the tSQLt framework.

Create a Table in Microsoft SQL Server

Learn how to create a table in SQL Server using T-SQL along with several different examples that build upon each other to create the final table.

DATETRUNC

Generate Random Dates in T-SQL

In this article we look at how to generate random dates in SQL Server to build a sample dataset along with code and examples