| Below are 14 new funtions added in sql 2012 which are categoriezed in 4 types as given below
(A)Conversion functions
(1)PARSE
(2)TRY_CONVERT
(3)TRY_PARSE
(B)Date and Time functions
(4)DATEFROMPARTS
(5)DATETIME2FROMPARTS
(6)DATETIMEFROMPARTS
(7)DATETIMEOFFSETFROMPARTS
(8)TIMEFROMPARTS
(9)EOMONTH
(10)SMALLDATETIMEFROMPARTS
(C)Logical functions
(11)CHOOSE
(12)IIF
(D)String functions
(13)CONCAT
(14)FORMAT | | |