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

Summarizing data using GROUP BY and HAVING clauses

You can summarize data to get counts, averages, sums, and more using GROUP BY in T-SQL queries. Greg Larsen shows you how.

T-SQL Comment Best Practices for SQL Server

Learn different ways to add comments to your T-SQL code when working with SQL Server along with several examples.

Which Error

The Ranking Function