SQL SERVER 2012 Functions – 14 New Functions – A Quick Guide

Last two weeks I wrote various blog posts on new functions introduced in SQL Server 2012. So many comments and request I have received from various readers that they would like to see everything together. I have put up a quick guide here where I am writing all the 14 new SQL Server 2012 functions linking them to my blog post as well Book On-Line for a quick reference.

SQLAuthority.com Book On-Line
Conversion functions
PARSE PARSE
TRY_CONVERT TRY_CONVERT
TRY_PARSE TRY_PARSE
Date and time functions
DATEFROMPARTS DATEFROMPARTS
DATETIME2FROMPARTS DATETIME2FROMPARTS
DATETIMEFROMPARTS DATETIMEFROMPARTS
DATETIMEOFFSETFROMPARTS DATETIMEOFFSETFROMPARTS
EOMONTH EOMONTH
SMALLDATETIMEFROMPARTS SMALLDATETIMEFROMPARTS
TIMEFROMPARTS TIMEFROMPARTS
Logical functions
CHOOSE CHOOSE
IIF IIF
String functions
CONCAT CONCAT
FORMAT FORMAT

I have personally bookmarked this post for my future reference. Trust me, some of the functions are really useful like CONCAT, FORMAT etc. In SQL Server, for years I have used + (plus) operator to concat the string. Now we can just use the function with the same.

Here is my question to you, what was the function you were waiting for this many years? Please leave a note in the comment section with a good example. I will post that on the blog with with due credit.

Reference: Pinal Dave (https://blog.sqlauthority.com)

,
Previous Post
SQL SERVER – Denali – Date and Time Functions – EOMONTH() – A Quick Introduction
Next Post
SQLAuthority News – Latest expressor Data Integration Platform Posts

Related Posts

8 Comments. Leave new

Leave a Reply Cancel reply

Menu
Exit mobile version