关于CASE的问题，急，在线等！

Question

SELECT 
    @DayNumberOfWeek,
    @ChineseDayNameOfWeek=CASE @DayNumberOfWeek 
                             WHEN 1 THEN '星期一'
                             WHEN 2 THEN '星期二'
                             WHEN 3 THEN '星期三'
                             WHEN 4 THEN '星期四'
                             WHEN 5 THEN '星期五'
                             WHEN 6 THEN '星期六'
                             ELSE '星期日'
                           END,
    @EnglishDayNameOfWeek=CASE @DayNumberOfWeek 
                             WHEN 1 THEN 'Monday'
                             WHEN 2 THEN 'Tuesday'
                             WHEN 3 THEN 'Wednesday'
                             WHEN 4 THEN 'Thursday'
                             WHEN 5 THEN 'Friday'
                             WHEN 6 THEN 'Saturday'
                             ELSE 'Sunday'
                           END

Answer 1

select datename(weekday,getdate())

Answer 2

SELECT @DayNumberOfWeek,
@ChineseDayNameOfWeek=CASE @DayNumberOfWeek WHEN 1 THEN '星期一'                                                                                   
                                                    WHEN 2 THEN '星期二'
                                                    WHEN 3 THEN '星期三'
                                                    WHEN 4 THEN '星期四'
                                                    WHEN 5 THEN '星期五'
                                                    WHEN 6 THEN '星期六'
                                                    ELSE '星期日'   END,
@EnglishDayNameOfWeek=CASE @DayNumberOfWeek WHEN 1 THEN 'Monday'                                                                                   
                                                    WHEN 2 THEN 'Tuesday'
                                                    WHEN 3 THEN 'Wednesday'
                                                    WHEN 4 THEN 'Thursday'
                                                    WHEN 5 THEN 'Friday'
                                                    WHEN 6 THEN 'Saturday'
                                                    ELSE 'Sunday'   END

Answer 3

set @ChineseDayNameOfWeek=datename(weekday,@DayNumberOfWeek)

Answer 4

实在要自己写，1-2楼上都没错：
when ... then (这里不需要 begin ... end ) else ... end
最后要一个 end，不管有没有 else。

Answer 5

SELECT @ChineseDayNameOfWeek = CASE @DayNumberOfWeek WHEN 1 THEN '星期一' WHEN 2 THEN '星期二'  WHEN 3 THEN '星期三' WHEN 4 THEN '星期四' WHEN 5 THEN '星期五' WHEN 6 THEN '星期六' ELSE '星期日' END,
@EnglishDayNameOfWeek = CASE @DayNumberOfWeek WHEN 1 THEN 'Monday' WHEN 2 THEN 'Tuesday' WHEN 3 THEN 'Wednesday' WHEN 4 THEN 'Thursday' WHEN 5 THEN 'Friday' WHEN 6 THEN 'Saturday' ELSE 'Sunday'  END

Answer 6

set language us_english
select datename(weekday,getdate())set language 简体中文
select datename(weekday,getdate())