SQL - negace příznaku

update CATALOGUE_ITEMS SET IS_Active = ~IS_DELETED from CATALOGUE_ITEMS

nebo druhá varianta

UPDATE CATALOGUE_ITEMS

SET IS_ACTIVE = case when IS_DELETED = 1 then 0 else 1 end;

Zdroj:
http://stackoverflow.com/questions/177762/boolean-not-in-t-sql-not-working-on-bit-datatype