case and if else statement in sql server

Saturday, 28 January 2012 01:52

// case and if else statement in sql server





DECLARE @MyVal INT



DECLARE @OUTPUTValues VARCHAR(200)

SET @MyVal = 1



SELECT @OUTPUTValues =

(

CASE  @MyVal

        WHEN 1 THEN 'test1'

        WHEN 2 THEN 'test2'

        WHEN 3 THEN 'test3'

        ELSE 'New'

END

)



PRINT @OUTPUTValues



SET @TestVal = 5



IF @MyVal= 1

SET @OUTPUTValues= '1'

ELSE IF @MyVal= 2

SET @OUTPUTValues= '2'

ELSE IF @MyVal= 3

SET @OUTPUTValues= '3'

ELSE

SET @OUTPUTValues= @MyVal



PRINT @OUTPUTValues