update tb set Anuma=case when Anuma=0 then 1  when Anuma=1 then 0 else Anuma end

------解决方案--------------------
SQL code

update tb
set 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 tb
SET Anuma=CASE(
 WHEN Anuma=0 THEN 1  
 WHEN Anuma=1 THEN 0 
)