저장프로시져 CASE문 예

CREATE PROC usp_case

     @userName nvarchar(10)

AS

 DECLARE @bYear INT 

 DECLARE @tti NCHAR(3) -- 띠

 SELECT @bYear = birthYear FROM userTbl

  WHERE name = @userName;

 SET @tti =

  CASE

   WHEN ( @bYear%12 =  0) THEN '원숭이'

   WHEN ( @bYear%12 =  1) THEN '닭' 

   WHEN ( @bYear%12 =  2) THEN '개' 

   WHEN ( @bYear%12 =  3) THEN '돼지' 

   WHEN ( @bYear%12 =  4) THEN '쥐' 

   WHEN ( @bYear%12 =  5) THEN '소' 

   WHEN ( @bYear%12 =  6) THEN '호랑이' 

   WHEN ( @bYear%12 =  7) THEN '토끼' 

   WHEN ( @bYear%12 =  8) THEN '용' 

   WHEN ( @bYear%12 =  9) THEN '뱀' 

   WHEN ( @bYear%12 =  10) THEN '말' 

   ELSE '양'

  END;

 PRINT @userName + '의 띠==> ' + @tti;