IF (Expression 1) BEGIN Statement 1; END ELSE IF (Expression 2) BEGIN Statement 2; END .......... ELSE BEGIN Default Statement; END
IF 1=1 SELECT 1 ELSE SELECT 0 -- returns 1 -- Definition IF Boolean_expression { sql_statement | statement_block } [ ELSE { sql_statement | statement_block } ]