IF / Else IF Condition in MSSQL

IF / Else IF Condition in MSSQL

-- HOW TO USE IF / ELSE IF CONDITION IN SQL

DECLARE @ColorCode Int 

SET @ColorCode = 2

IF (@ColorCode = 1)
BEGIN
 SELECT 'RED' AS ColorName
END
IF (@ColorCode = 2)
BEGIN
 SELECT 'GREEN' AS ColorName
END
IF (@ColorCode = 3)
BEGIN
 SELECT 'BLUE' AS ColorName
END