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.
(no tags)
Slide Deck 892 KB , MP4 Video Low 66 MB , Demo Code 6 KB , MP4 Video Med 98 MB , MP4 Video High 216 MB , MP4 Video HD 412 MB