Chapter 6. Transact-SQL Enhancements

IN THIS CHAPTER

T-SQL Versus SQLCLR

The TOP Operator

The TABLESAMPLE Clause

Common Table Expressions (CTEs)

Large Object Data Type Enhancements

T-SQL Error Handling

DDL Triggers

Event Notifications

Snapshot Isolation

Ranking Functions

New Relational Operators: PIVOT, UNPIVOT, and APPLY

The OUTPUT Clause

The BULK Rowset Provider

New Declarative Referential Integrity Actions

Metadata Views and Dynamic Management Views

Miscellaneous T-SQL Enhancements

Even though SQL Server 2005 supports writing stored procedure, functions, and triggers using .NET languages such as C#, Transact-SQL (T-SQL) will still be the primary language that database developers and DBAs will use to write scripts ...

Get Microsoft® SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition) now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.