In Case You Missed It: Recently Added T-SQL Features

When organizations are running a mission-critical system on SQL Server, they are often reluctant to upgrade to each new release of SQL Server and risk breaking functionality of their critical applications. It’s not uncommon to find organizations still running applications on SQL Server 2000. It’s quite possible that if you are reading this book you may be upgrading to SQL Server 2012 from SQL Server 2000 or 2005. If this is the case, this section is intended for you. There have been a number of T-SQL enhancements since SQL Server 2000. The following sections highlight some of the more useful new T-SQL commands and features introduced in SQL Server 2005 and the SQL Server 2008 and 2008 R2 releases ...

Get Microsoft® SQL Server 2012 Unleashed 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.