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)
8 Comments. Leave new
Thanks a lot sir.
Great series Pinal, keep up the good work!
Great Post..Thanks a lot :)
Good one
Is there a master list at Microsoft somewhere where all the new functionality is listed? They’re white paper is incomplete. For example there are other functions related to OVER.
really nice, thanks a lot.
great
thanks
great post