SQL Server 2012 introduces 14 new built-in functions. These functions ease the path of migration for information workers by emulating functionality that is found in the expression languages of many desktop applications. However these functions will also be useful to experienced users of SQL Server.

The new functions are:

Conversion functions

• PARSE (Transact-SQL)
• TRY_CONVERT (Transact-SQL)
• TRY_PARSE (Transact-SQL)

Date and time functions

• DATEFROMPARTS (Transact-SQL)
• DATETIME2FROMPARTS (Transact-SQL)
• DATETIMEFROMPARTS (Transact-SQL)
• DATETIMEOFFSETFROMPARTS (Transact-SQL)
• EOMONTH (Transact-SQL)
• SMALLDATETIMEFROMPARTS (Transact-SQL)
• TIMEFROMPARTS (Transact-SQL)

Logical functions

• CHOOSE (Transact-SQL)
• IIF (Transact-SQL)

String functions

• CONCAT (Transact-SQL)
• FORMAT (Transact-SQL)