Description : in this post display color code name when pass int value in @ColorCode variable if pass 2 in @ColorCode = 2 then it check condition and result will return "GREEN" bacause color code = 2 is green
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
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
No comments:
Post a Comment