SQL Server for Developers

SQH06 Exploring T-SQL Enhancements: Windowing and More


9:30am - 10:45am

Level: Intermediate

Leonard Lobel



Sleek Technologies, Inc.

SQL Server 2014 doesn't add much to T-SQL, but SQL Server 2012 enhanced the database's native programming language with numerous features. If you're not up to speed, this informative and demo-packed session will guide you through the powerful windowing enhancements with the OVER clause, new T-SQL functions (all 22 of them), improved error handling with THROW, server-side paging with OFFSET/FETCH NEXT, sequence genera-tors, rich metadata discovery techniques and contained databases. If you want to program the latest T-SQL enhancements in SQL Server, you won't want to miss this session!

You will learn:

  • New T-SQL features in SQL Server 2012
  • Examine 22 new T-SQL functions, including 8 new analytic windowing functions
  • Explore OVER, THROW, OFFSET, metadata discovery, and contained data-bases