Chapter 6. The Code Chapter

This chapter contains what might seem like a bunch of random code. In fact, I’ve attempted to illustrate some of the most useful new functionality in SQL Server 2005 as well as interesting functionality that you might not uncover without hints or direction. Additionally, I hope that some of the code provided in this chapter will help further clarify new features I introduced in the other chapters. I limited myself to Transact-SQL language enhancements.

Microsoft has continued to make improvements to the Transact-SQL language, despite all the fuss being made over using the .NET Framework to develop stored procedures, UDTs, and the like. The Transact-SQL language has new extensions that include greater support for query ...

Get SQL Server 2005 Distilled 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.