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.
|Date and time functions|
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)