Microsoft SQL Server 2012 introduces 14 new built-in functions. These functions are divided into 4 categories.
In this article I will be covering usage & functionality of these new 14 functions. I strongly feel, these functions are very useful for developer point of view.
These new functions are:
1) Conversion functions
· PARSE (Transact-SQL)
· TRY_PARSE (Transact-SQL)
· TRY_CONVERT (Transact-SQL)
2) Date and time functions
· DATEFROMPARTS (Transact-SQL)
· DATETIMEFROMPARTS (Transact-SQL)
· DATETIME2FROMPARTS (Transact-SQL)
· SMALLDATETIMEFROMPARTS (Transact-SQL)
· DATETIMEOFFSETFROMPARTS (Transact-SQL)
· TIMEFROMPARTS (Transact-SQL)
· EOMONTH (Transact-SQL)
3) Logical functions
· CHOOSE (Transact-SQL)
· IIF (Transact-SQL)
4) String functions
· CONCAT (Transact-SQL)
· FORMAT (Transact-SQL)
