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

Different ways to Convert a SQL INT Value into a String Value

In this article we cover different ways to convert a SQL Server numeric value into a string value.