SQL SERVER 在update set中 使用 case when的方法

–这里有一个问题一定要注意，else 后面一定要将原有的值放进来或者设置一个默认值，否则除了a、b意外的值会被置成null

update er_bxzb set zyx27 = case when zyx27 = ‘是’ then ‘Y’ when zyx27 = ‘否’ then ‘N’ else zyx27 end;

update er_bxzb set zyx27 = case when zyx27 = ‘是’ then ‘Y’ when zyx27 = ‘否’ then ‘N’ else ‘~’ end;

–这种没有else的会出现null的情况

update er_bxzb set zyx27 = case when zyx27 = ‘是’ then ‘Y’ when zyx27 =
‘否’ then ‘N’ end;