Home » SQL Server » New built-in Logical functions in SQL Server 2012……..Part 4 of 5

New built-in Logical functions in SQL Server 2012……..Part 4 of 5


Microsoft SQL Server 2012 introduces 14 new built-in functions. 2 Out 14 explained below.

Logical functions

· CHOOSE : 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.

CHOOSE ( index, val_1, val_2 [, val_n ] )

· IIF : It returns one of the two values depending upon whether the Boolean expression evaluates to either True or False.

IIF ( boolean_expression, true_value, false_value )

Advertisements

2 Comments

  1. Wonderful beat ! I wish to apprentice whilst you amend your site, how can i subscribe for a weblog web site? The account aided me a acceptable deal. I have been tiny bit familiar of this your broadcast provided brilliant clear idea

  2. We’re a group of volunteers and opening a brand new scheme in our community. Your website offered us with useful info to paintings on. You’ve done an impressive job and our entire group can be grateful to you.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: