The Baker's Dozen: What's New in SQL Server 2012 (Part 2 of 13): New Transact-SQL Enhancements
Each new version of Microsoft SQL Server contains a number of language enhancements for retrieval, summarizing, and management of data. SQL Server 2005 had new features for PIVOT, RANK, recursive queries, and more. SQL Server 2008 had GROUPING SETS, MERGE, and more. Transact-SQL in SQL Server 2012 offers several new features to help application developers and database administrators, with capabilities such as sequence objects (a database-level identity), new window functions for analytic queries (such as LAG, LEAD, Percent Rank, Cumulative Distance, and a new way to calculate MEDIANS), new ways of paging through result sets (with new OFFSET and FETCH keywords), and more. In this webcast, Kevin Goff goes through a series of code samples to illustrate scenarios where these new language features can be used.
Download: