SQL Server 2012 - New Functions

Microsoft SQL Server 2012 introduces 14 new built-in functions. Microsoft keeps on improving there products kudos to them.

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)

In addition to the 14 new functions, one existing function has been changed. The existing LOG (Transact-SQL) function now has an optional second baseparameter.