SQL：获取中文周几

declare @week nvarchar(2) = 
    case DatePart(DW, GetDate())
        when 1 then '周日'
        when 2 then '周一'
        when 3 then '周二'
        when 4 then '周三'
        when 5 then '周四'
        when 6 then '周五'
        when 7 then '周六'
    end