SQL SERVER IF STATEMENT

SQL SERVER IF STATEMENT

-- THEORY:

-- SELECT IIF(TEST CONDITION,'FIRST ANSWER','SECOND ANSWER');

-- EXAMPLE 1:

SELECT IIF(1>0,'TRUE',IIF(2>1,'TRUE','FALSE')) AS [IIF1];

-- EXAMPLE 2

SELECT IIF((2 < 1 AND 1 > 0),'TRUE','FALSE') AS [IIF2];

-- EXAMPLE 2

SELECT IIF((2 > 1 AND 1 > 0),'TRUE','FALSE') AS [IIF3];