IF & ELSE
IF @MyVar > 200
BEGIN
PRINT('greater than 200')
END
ELSE IF @MyVar = 200
BEGIN
PRINT('equal to 200')
END
ELSE
BEGIN
PRINT('less than 200')
END
IF @MyVar > 200
BEGIN
PRINT('greater than 200')
END
ELSE IF @MyVar = 200
BEGIN
PRINT('equal to 200')
END
ELSE
BEGIN
PRINT('less than 200')
END