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 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.

Start your free trial