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

The Broken UDF

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