O'Reilly logo

Microsoft® SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition) by Scalability Experts, Inc.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required