what does T-SQL IIF statement do in SQL Server?

Options :
  1. IIF return one of two value either true or false based on expression evaluation.
  2. Expression will execute two time
  3. It will check the null value of based on the expression evolution.
  4. There is no IIF in T-SQL


Answer and Explanation :-

Answer: Option 1

Explanation:

IIF return one of two value either true or false based on expression evaluation. Syntax

IIF(Boolean expression, true value, false value)

How do you rate this queston?  Very Easy  Easy  Average  Above Average  Tough

Previous Question : What is the maximum count of column you can have in SQL Server 2012

Next Question : From which version TRY_PARSE() function is included in SQL Server?

Click here for free online test on SQL Server

Responses


 (Getemail alerts when others member replies)

More available Categories:








... but I must reluctantly observe that two causes, the abbreviation of time, and the failure of hope, will always tinge with a browner shade the evening of life.
-Edward Gibbon Memoirs of My Life