update tblcontract_son set field2 = (case when isnull(field1,'') = '' then 200 end),field1 = (case when isnull(field1,'') <> '' then 200 end) where bh = 21
update tblcontract_son set field2=case when isnull(field1,'')='' then 200 else field2 end, field1=case when isnull(field1,'')='' then 200 else field1 end where bh=21
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货