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

September 21, 2011 by pinaldave

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)