March 2006
Beginner to intermediate
336 pages
7h 49m
English
Content preview from SQL Server 2005 DistilledBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...