IF ELSE syntax in SQL server code example
Example 1: else if sql server
IF (Expression 1)
BEGIN
Statement 1;
END
ELSE IF (Expression 2)
BEGIN
Statement 2;
END
..........
ELSE
BEGIN
Default Statement;
END
Example 2: t-sql if else
IF 1=1
SELECT 1
ELSE
SELECT 0
-- returns 1
-- Definition
IF Boolean_expression
{ sql_statement | statement_block }
[ ELSE
{ sql_statement | statement_block } ]