Chapter 14. Advanced T-SQL topics

After completing this chapter, you will be able to

  • Perform aggregating, grouping, and windowing.

  • Use SQL Server temporary objects.

  • Handle T-SQL errors inside of queries.

  • Add control logic around and inside T-SQL statements.

So far, the T-SQL statements and logic you have constructed have been very basic and straightforward. In this chapter, you will learn about additional constructs to enhance the functionality of T-SQL code. First, you will examine how to perform aggregations, windowing, and grouping with T-SQL. Next, you will learn how to use temporary objects in Microsoft SQL Server. Finally, you will see examples of how to handle errors and control the flow of T-SQL queries.

Aggregating, windowing, and grouping ...

Get Microsoft® SQL Server® 2012 Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.