Greg Larsen’s series of articles on the building blocks of writing code in T-SQL Items published so far:

1. The basic T-SQL Select Statement
2. Ordering a result set in SQL Server
3. The ins and outs of joining tables in SQL Server
4. Summarizing data using GROUP BY and HAVING
5. The Basics of Inserting Data into a SQL Server Table
6. The Basics of Updating Data in a SQL Server Table
7. The Basics of Deleting Data from a SQL Server Table
8. Manage Data Over Time with SQL Server MERGE Statement
9. Using TOP clause in a SELECT statement
10. Paging Data in T-SQL
11. Using a Subquery in a SELECT statement