Category Archives: SQL 2012 New Features

PARSE() – SQL Server Function usage with Screenshot

SQL Server Denali CTP3 has introduces a new function PARSE() to translate the result of an expression to specified data type that too is specified language. PARSE() returns the result of an expression, translated to specified data type if the translation is possible, otherwise, it raises an error. PARSE (), expects three parameters, string_value – [...]

TRY_PARSE() – SQL Server Function usage with Screenshot

SQL Server Denali CTP3 has introduces a new function TRY_PARSE() to translate the result of an expression to specified data type. TRY_PARSE() tries to translate the result of an expression to specified data type if the translation is possible, otherwise, it returns NULL. Moreover, we can also specify the CULTURE, during this conversion. CULTURE, means [...]

TRY_CONVERT() SQL Server Example – Screenshot

SQL Server Denali CTP3 has introduces a new function TRY_CONVERT() to evaluates whether a data type conversion is possible or not? TRY_CONVERT(), checks whether typecasting / datatype conversion from one datatype to other datatype is possible or not and if it possible then it converts the source data type into the target type and if [...]

How to use IIF() in SQL Server ?

SQL Server Denali CTP3 has introduces a new function IIF() to evaluates specified expression and returns specified true/false values. IIF(), is kind of shorthand way of writing a CASE expression where we can expect only two result either true or false. This function is same as available in other languages. IIF(), accepts three parameters, First [...]

CHOOSE – SQL Server Fuction

SQL Server Denali CTP3 has introduces a new function CHOOSE() for selecting a specific value from a given options . Choose () function is used to return any specific value from a given list, CHOOSE(), accepts two parameters, where the first parameter is Index – Numeric expression that results in a value between 1 and [...]

SQL Server String function – FORMAT- Denali

SQL Server Denali CTP3 has introduces a new function FORMAT() for formatting of DATETIME and numeric values . FORMAT () – Converts a date time type or number type value to text string according to the specified format. In previous versions this can be accomplished using CAST and CONVERT as below: — Alternate of FORMAT [...]

SQL Server Denali New Function – CONCAT

CONCAT – SQL Server String concatenation function CONCAT is new function introduced in SQL Server Denali (2012) CTP3. This function is same as Microsoft excel and returns a string that is the result of concatenating two or more string values This function minimum requires two input values to concatenate the string. — SQL Server CONCAT [...]