create table aa0(
num int
)
goinsert into aa0 values(1)
insert into aa0 values(0)
insert into aa0 values(0)
insert into aa0 values(1)select * from aa0--测试
update aa0 set num=case num when 0 then 1 else 0 end
num int
)
goinsert into aa0 values(1)
insert into aa0 values(0)
insert into aa0 values(0)
insert into aa0 values(1)select * from aa0--测试
update aa0 set num=case num when 0 then 1 else 0 end
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货