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.

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=""> <s> <strike> <strong>

Powered by sweet Captcha

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at SteveStedman.com with my newsletter.
Newsletter signup form.

Stedman Solutions

StedmanSolutionsRemoteSkilledDBA

Common Table Expressions Book

Paperback:

Kindle: