Awesome new T-SQL candy in SQL Server 2012
SQL Server 2012 brings a whole bag of new features. We'll focus on the awesome new stuff that will make your T-SQL development a breeze.
How did you do your paging so far? Got mad at the lack of proper support? Not any longer! Now there's OFFSET to help you with that
Remember when you had to do those running totals with CLR, subqueries, quirky updates or (GASP!) cursors?No more! Enter the new WINDOWING FUNCTIONS that offer a simple solution to that problem and a bunch of new possibilities.
Ever had identity problems? Let me show you the power of new SEQUENCES!
But wait, there's more! We'll even take a look at the upgraded ERROR HANDLING, new FORMATTING and CONVERTING functions, awesome METADATA DISCOVERY and more.