How to negate a bit column value in SQL

Just use this:

UPDATE mytable SET IsEditable=IsEditable^1

If you want to test it:

SELECT CONVERT(bit,0)^1, CONVERT(bit,1)^1

You can use bitwise NOT operator:

update mytable set IsEditable = ~IsEditable

Related