sql server - How to negate a bit column value in SQL -


how update table column in order revert value(set true if value false , false true! null remains null).

please exclude solutions 1 uses case when or iff() want like

update mytable set iseditable = !iseditable 

you can use bitwise not operator:

update mytable set iseditable = ~iseditable 

Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

firemonkey - How do I make a beep sound in Android using Delphi and the API? -