In SQL Server 2012, there are two new logical functions being introduced, namely: IIF() and CHOOSE(). Today we will quickly take a look at the logical CHOOSE() function. This function is very simple and it returns specified index from a list of values. If Index is numeric, it is converted to integer. On the other hand, if the index is greater than the element in the list, it returns NULL.
SQL SERVER – Denali – Logical Function – IIF() – A Quick Introduction
In SQL Server Denali, there are two new logical functions being introduced, namely: IIF() CHOOSE() Today, we will have a look at the IIF() function. This function does not need any introduction as developers have used this function in various languages from ages. This function is shorthand way for writing…
Read More
SQL SERVER – Denali – Conversion Function – Difference between PARSE(), TRY_PARSE(), TRY_CONVERT()
In SQL Server Denali, three new conversion functions have been introduced, namely,
PARSE()
TRY_PARSE()
TRY_CONVERT()
SQL SERVER – Denali – Conversion Function – TRY_CONVERT() – A Quick Introduction
In SQL Server Denali, there are three new conversion functions being introduced, namely: PARSE() TRY_PARSE() TRY_CONVERT() Today we will quickly take a look at the TRY_CONVERT() function. The TRY_CONVERT() function is very similar to CONVERT function which is avail in SQL Server already. Only difference is that it will attempt…
Read MoreSQL SERVER – Denali – Conversion Function – TRY_PARSE() – A Quick Introduction
In SQL Server Denali, there are three new conversion functions being introduced, namely: PARSE() TRY_PARSE() TRY_CONVERT() Today we will quickly take a look at the TRY_PARSE() function. The TRY_PARSE() function can convert any string value to Numeric or Date/Time format. If the passed string value cannot be converted to Numeric…
Read MoreSQL SERVER – A Guide to Integrating SQL Server with XML, C#, and PowerShell – Book Available for SQL Server Certification
We recently gave away 7 physical books of Joes 2 Pros Book Volume 5. The response to following questions was overwhelming and was excellent. The book is available to purchase now in India and USA. This is great news as I often get request that where one can learn SQL…
Read MoreSQL SERVER – Denali – Conversion Function – PARSE() – A Quick Introduction
In SQL Server Denali, there are three new conversion functions being introduced, namely: PARSE() TRY_PARSE() TRY_CONVERT() Today we will quickly look at PARSE() function. PARSE() function can convert any string value to Numeric or Date/Time format. If passed string value cannot be converted to Numeric or Date/Time format, it will…
Read More