SQL Saturday Presentation

I am at SQL Saturday in Vancouver BC today.

Here is the download of my presentation.

Download zip file.

Here is the presentation outline.

• OVER Clause Enhancements
• ROWS PRECEDING, FOLLOWING, UNBOUNDED
• RANGE PRECEDING, FOLLOWING, UNBOUNDED
• IIF – Immediate IF or Inline IF (from Access)
• CHOOSE (from Access)
• OFFSET / FETCH
• FORMAT
• CONCAT
• SEQUENCE (from Oracle)
• sp_describe_first_result_set
• New Date and Time Functions
• Conversion Functions
• PARSE, TRY_PARSE, TRY_CONVERT
• THROW exception