帮忙写 一条sql语句 Anum字段 如果值是0就更新为1, 如果值是1就更新为0,该怎么解决

update tb set Anuma=case when Anuma=0 then 1  when Anuma=1 then 0 else Anuma end
------解决方案--------------------
SQL code
update tbset anuma = (case anuma when 1 then 0 when 0 then 1 else anuma end)
------解决方案--------------------
探讨

SQL code

update tb set Anuma=abs(Anum-1)

------解决方案--------------------
SQL code
UPDATE tbSET Anuma=CASE( WHEN Anuma=0 THEN 1   WHEN Anuma=1 THEN 0 )