Select from following answers:- IIF

- CASE
- SWITCH
- DECODE
- All Above
IIF() is introduced in SQL Server 2012. It returns one of two values, depending on whether the Boolean expression evaluates to true or false.
Example:
DECLARE @FirstArg INT = 100
DECLARE @SecondArg INT = 200
SELECT IIF ( @FirstArg > @SecondArg , 'TRUE', 'FALSE' )
AS [Output]
GO
OUTPUT:
FALSE
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator