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
- FORMAT
- CONCAT
- SEQUENCE (from Oracle)
- sp_describe_first_result_set
- New Date and Time Functions
- Conversion Functions
- PARSE, TRY_PARSE, TRY_CONVERT
- THROW exception
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!