• Article

Transact-SQL

Transact-SQL has long been the basis for all SQL Server programming models. SQL Server 2005 provides many new language capabilities for developing scalable database applications. These SQL Server programming enhancements include error handling, new recursive query capabilities, and support for new SQL Server Database Engine capabilities.

SQL Server 2005 Transact-SQL Enhancements SQL Server 2005 Transact-SQL Enhancements

This white paper introduces several of the new enhancements to Transact-SQL in SQL Server 2005. These new features can enhance your SQL Server programming capabilities by increasing your expressive power, the performance of your queries, and your error management capabilities. This paper focuses mainly on relational enhancements that are conceptually new and demonstrates these through practical examples.

Articles and Columns

Editing Transact-SQL Code in SQL Server 2005

Get an overview of the T-SQL development tools available in Microsoft SQL Server 2005 Management Studio to enhance your SQL Server programming experience.
How to Implement an Automatic Sliding Window in a Partitioned Table on SQL 2005

Take advantage of horizontal partitioning in SQL Server 2005 to create a sliding window on a partitioned table. This SQL Server programming sample implementation shows a solution entirely in T-SQL.

Webcasts

Resources in the SQL Server Books Online

My Learning