Programming T-SQL Enhancements in SQL Server 2012
As SQL Server evolves, so does Microsoft continue to improve and enhance Transact SQL (T-SQL)—the native procedural programming language that developers have been using since the birth of the product. In SQL Server 2012, T-SQL remains the primary language for programming the relational database engine.
In this informative and demo-packed session, Lenni will guide you through the T-SQL enhancements in the very latest release of SQL Server. We’ll dive into powerful new 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 generators, and rich metadata discovery techniques. If you want to learn the new T-SQL enhancements in SQL Server 2012, you won’t want to miss out on this session!
Sorry, there are no downloads available for this session.
Leonard Lobel is a SQL Server MVP and cofounder/CTO of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. Programming since 1979, He is also a consultant, trainer, author, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, SQL Bits, CodeCamp, and other industry conferences worldwide. Lenni is also lead author of the MS Press book “Programming Microsoft SQL Server 2012.” He can be reached at firstname.lastname@example.org.
The video is not available to view online.