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.

SQL SERVER 2012 Functions - 14 New Functions - A Quick Guide function

SQLAuthority.comBook On-Line
Conversion functions
PARSEPARSE
TRY_CONVERTTRY_CONVERT
TRY_PARSETRY_PARSE
Date and time functions
DATEFROMPARTSDATEFROMPARTS
DATETIME2FROMPARTSDATETIME2FROMPARTS
DATETIMEFROMPARTSDATETIMEFROMPARTS
DATETIMEOFFSETFROMPARTSDATETIMEOFFSETFROMPARTS
EOMONTHEOMONTH
SMALLDATETIMEFROMPARTSSMALLDATETIMEFROMPARTS
TIMEFROMPARTSTIMEFROMPARTS
Logical functions
CHOOSECHOOSE
IIFIIF
String functions
CONCATCONCAT
FORMATFORMAT

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

Menu