O'Reilly logo

Microsoft SQL Server 2012 Bible by Aaron Nelson, Jose Chinchilla, Patrick LeBlanc, Jorge Segarra, Adam Jorgensen

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

What's New in T-SQL for 2012

New features and enhancements in SQL Server 2012 are highlighted throughout this book. However, there are a few items that deserve a mention within this chapter.

Debugging Enhancements

Debugging within SQL Server Management Studio has historically been an exercise in frustration. With SQL Server 2012, you now have the ability to set conditional breakpoints, hit count thresholds, and import and export the breakpoints to an XML file for portability. In addition, you may now fully customize the keyboard for debug mode.

Metadata Discovery

Two new enhancements, delivered via system stored procedures and functionally equivalent dynamic management objects (DMO), provide metadata about what the result set will be when a T-SQL batch is executed.

Sys.dm_exec_describe_first_result_set

The DMO sys.dm_exec_describe_first_result_set returns metadata for the first possible result set of the Transact-SQL batch. The metadata provided is similar to what you might see if you query sys.objects. The huge advantage is that it evaluates all columns in the query, consolidating object metadata into one result set. The system stored procedure sp_describe_first_result_set provides the same information. Simply pass the T-SQL batch to the DMO, along with any parameters and their data types, as well as the browse_information_mode parameter.

SELECT * 
FROM sys.dm_exec_describe_first_result_set 
  (N'TSQL', N'Parameters', 0); 

The following example returns three rows of metadata from ...

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