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:-








I've come to the conclusion that people who wear headphones while they walk, are much happier, more confident, and more beautiful individuals than someone making the solitary drudge to work without acknowledging their own interests and power.
-Jason Mraz