case when语法

来源：百度文库编辑：神马文学网时间：2024/04/28 12:29:20

string sql = string.Format("update {0} set IsShopRecommend=(case when Recommend=1 then 0 else 1 end)whereID=@ID and status={1}", table, Convert.ToInt32(Status.OnAuction--枚举));
CASE
WHEN CateFolder IS NULL THEN CurrFolder
WHEN CurrFolder IS NULL THEN CateFolder
ELSE Catefolder + '/ ' + CurrFolder
END
select count(case a.zt when '07' then a.bs end)+
count(case a.zt when '11' then a.bs end)
from dj_zt a
where a.qylx_dm = '03'
select
(case when 语文>=80 then '优秀'
when 语文>=60 then '及格'
else '不及格') as 语文,
(case when 数学>=80 then '优秀'
when 数学>=60 then '及格'
else '不及格') as 数学,
(case when 英语>=80 then '优秀'
when 英语>=60 then '及格'
else '不及格') as 英语,
from table

case when语法 [典型的行列转换，case when可以搞定。 case study case study Use Case Case Interview What is a Case? Case Analysis-Conceptual Framework Case-Based Reasoning Case Analysis-Conceptual Framework shell case--八个部分 Case-Based Reasoning When You Are Old 《入乡随俗》(When In Rome) When You Are Old when you believe... when you are old When You Are Old Use Case入门与实例用例(Use Case)的优势 When to use “on” and when to use “in” VoIP for All...But When? When a child is born When small is career beautiful