SQL 2012 - new function
Conversion functions
• PARSE
• TRY_CONVERT
• TRY_PARSE
Date and time functions
• DATEFROMPARTS
• DATETIME2FROMPARTS
• DATETIMEFROMPARTS
• DATETIMEOFFSETFROMPARTS
• EOMONTH
• SMALLDATETIMEFROMPARTS
• TIMEFROMPARTS
Logical functions
• CHOOSE
• IIF
String functions
• CONCAT
• FORMAT
Reference : Programmability Enhancements (Database Engine)
