age= case when B.age=0 then 2sql还有这种写法

1 update A set A.name='xxx', age= case when B.age=0 then 2 2 when B.birthday>'2018-01-02' then 1 end 3 from tt

 

转载于:https://www.cnblogs.com/ZkbFighting/p/10270513.html