I am at SQL Saturday in Vancouver BC today.
Here is the download of my presentation.
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
- SEQUENCE (from Oracle)
- New Date and Time Functions
- Conversion Functions
- PARSE, TRY_PARSE, TRY_CONVERT
- THROW exception