Microsoft® SQL Server 2005 Unleashed

Chapter 35. What’s New for Transact-SQL in SQL Server 2005

IN THIS CHAPTER

• The xml Data Type

• The max Specifier

• TOP Enhancements

• The OUTPUT Clause

• Common Table Expressions

• Ranking Functions

• PIVOT and UNPIVOT

• The APPLY Operator

• TRY...CATCH Logic for Error Handling

• The TABLESAMPLE Clause

SQL Server 2005 introduces some new features and changes to the Transact-SQL (T-SQL) language. The focus in this chapter is primarily on the new and modified Data Manipulation Language (DML) commands and programming constructs built into T-SQL. The various new and updated Data Definition Language (DDL) commands are covered in other chapters, primarily those in Part IV, “Database Administration.”

SQL Server 2005 doesn’t really provide many new Transact-SQL DML statements over ...