If en sql

IF @variable
BEGIN
--
END
ELSE IF @variable
BEGIN
--
END
ELSE
BEGIN
--
END

fuente:https://stackoverflow.com/questions/20413064/multiple-separate-if-conditions-in-sql-server