Microsoft SQL Server 2012 introduces 14 new built-in functions. 2 Out 14 explained below.
· CONCAT : CONCAT takes a variable number of string arguments and concatenates them into a single string. It requires a minimum of two input values; otherwise, an error is raised. All arguments are implicitly converted to string types and then concatenated. Null values are implicitly converted to an empty string.
CONCAT ( string_value1, string_value2 [, string_valueN ] )
· FORMAT : Use the FORMAT function for locale-aware formatting of date/time and number values as strings. This really a good function because converting a date into desired format with convert along with format number is little uneasy.
FORMAT ( value, format [, culture ] )