sql case when的用法？

[qingyshi]

sql case when的用法？

[muzhenxing013]

联机丛书

[水族杰纶]

select case when 1=1 then '正確' else '錯誤' end

[yfq85825]

case函数来返回今天是星期几

declare @today int
set @today= datepart(dw,getdate())

select 今天是= case
                  when @today=1 then'星期天'    
                  when @today=2 then'星期一'
                  when @today=3 then'星期二' 
                  when @today=4 then'星期三' 
                  when @today=5 then'星期四' 
                  when @today=6 then'星期五' 
                  when @today=7 then'星期六' 
               end

[DumDum]

case @ss when 1 then '1' 
         when 2 then '2'
         when 3 then '3'
         .
         .
         .
         else '0'
end

或

case  when @ss=1 then '1'
      when @ss=2 then '2'
     ....
      else '0'
end

[昵称被占用了]

看联机帮助