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 online test on SQL Server

Responses


 (Getemail alerts when others member replies)

More available Categories:-








Every problem is a gift - without problems we would not grow.
-Anthony Robbins