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.

6 Responses to What’s New in TSQL 2012

  1. Pingback: » Sessions for Code Camp in 2 weeks Steve Stedman

  2. Pingback: » Sessions Submitted for SQL Saturday – Olympia Steve Stedman

  3. Pingback: » TSQL 2012 CHOOSE Function Steve Stedman

  4. Pingback: » Home after Seattle (Redmond) Code Camp 2012 Steve Stedman

  5. Pingback: » Exploring the TSQL Enhancements in SQL Server 2012 – Slides and Sample Code Steve Stedman

  6. Pingback: » Code Camp in Redmond Today— Steve Stedman

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Powered by sweetCaptcha