What’s New in TSQL 2012
Audience
This class is intended for developers and DBA’s who have used SQL Server and want to get up to speed on the latest TSQL enhancements in SQL Server 2012.
Course Description
Outline
- OVER Clause Enhancements
- ROWS PRECEDING, FOLLOWING, UNBOUNDED
- RANGE PRECEDING, FOLLOWING, UNBOUNDED
- IIF
- CHOOSE
- OFFSET / FETCH
- FORMAT
- CONCAT
- SEQUENCE
- sp_describe_first_set
- DATEFROMPARTS
- THROW exception
- PARSE
- TRY_PARSE
- TRY_CONVERT
- Analytic Functions
This new class will be unveiled at Seattle Code Camp.
Pingback: » Sessions for Code Camp in 2 weeks Steve Stedman
Pingback: » Sessions Submitted for SQL Saturday – Olympia Steve Stedman
Pingback: » TSQL 2012 CHOOSE Function Steve Stedman
Pingback: » Home after Seattle (Redmond) Code Camp 2012 Steve Stedman
Pingback: » Exploring the TSQL Enhancements in SQL Server 2012 – Slides and Sample Code Steve Stedman
Pingback: » Code Camp in Redmond Today Steve Stedman