The bit field in SQL Server implements the reverse operation

Update Fct_stockmove set disabled=disabled^1 WHERE moveid= ' Dce268e0-2cb3-4d17-ac4e-0046fb459cad ';

1. Using the take-back operator
Update T1 set C1=~C1;

2. Use XOR operator for INT type operation
Update T1 set c1=c1^1;

3. Using arithmetic methods to implement
Update T1 set c1= (c1+1)%2;
Or
Update T1 set C1=abs (c1-1);

4.case when statement
Update TableName Set state=
(case state is 0 then 1 while 1 then 0 else 0 end);

Source text: http://yimenghust.iteye.com/blog/1601707

The bit field in SQL Server implements the reverse operation