Last two weeks I have written various blog post on new functions introduced in SQL Server Denali. 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 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.
Reference: Pinal Dave (
http://blog.SQLAuthority.com
)
Thanks a lot sir.
Great series Pinal, keep up the good work!
Pingback: SQL SERVER – Denali – Startup Parameters Easy to Configure « Journey to SQLAuthority
Great Post..Thanks a lot :)
Pingback: SQL SERVER – A Quick Trick about SQL Server 2012 CONCAT function « SQL Server Journey with SQLAuthority
Good one
Pingback: SQL SERVER – A Quick Trick about SQL Server 2012 CONCAT Function – PRINT « SQL Server Journey with SQLAuthority
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.
http://sqlwithmanoj.wordpress.com/2011/07/27/denali-tsql-new-features-built-in-functions/
Pingback: SQL SERVER – Detecting Leap Year in T-SQL using SQL Server 2012 – IIF, EOMONTH and CONCAT Function « SQL Server Journey with SQL Authority
really nice, thanks a lot.
great
thanks
great post