using if else in ms sql server code example
Example: else if sql server
IF (Expression 1)
BEGIN
Statement 1;
END
ELSE IF (Expression 2)
BEGIN
Statement 2;
END
..........
ELSE
BEGIN
Default Statement;
END
IF (Expression 1)
BEGIN
Statement 1;
END
ELSE IF (Expression 2)
BEGIN
Statement 2;
END
..........
ELSE
BEGIN
Default Statement;
END