New Post has been published on Varinder Sandhu 's Blog
New Post has been published on http://www.varindersandhu.in/2011/09/23/sql-server-denali-new-logical-functions/
SQL Server Denali – New Logical Functions
<!-- google_ad_client = "pub-2404605494811633"; google_alternate_color = "FFFFFF"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "FFFFFF"; google_color_link = "0000FF"; google_color_bg = "FFFFFF"; google_color_text = "000000"; google_color_url = "008000"; google_ui_features = "rc:6"; //-->
There are two new Logical functions are introduced in Denali. Let‘s have a look
It Returns one of two values, depending on whether the Boolean expression evaluates to true or false.
IIF is a shorthand way for writing a CASE statement. It evaluates the Boolean expression passed as the first argument, and then returns either of the other two arguments based on the result of the evaluation. That is, the true_value is returned if the Boolean expression is true, and the false_value is returned if the Boolean expression is false or unknown. true_value and false_value can be of any type.
--Syntax IIF ( boolean_expression, true_value, false_value ) --Example SELECT IIF (50 > 20, True, False) AS Result; --Result True
Returns the item at the specified index from a list of values.
CHOOSE acts like an index into an array, where the array is composed of the arguments that follow the index argument. The index argument determines which of the following values will be returned.
--Syntax CHOOSE ( index, val_1, val_2 [, val_n ] ) -- Example SELECT CHOOSE ( 3, 'Varinder', 'Dinesh', 'Ranjoyt', 'Vikram' ) AS Result; --Result Ranjoyt
