How to update bit value in SQL

Question

I have a table in which I have 2 Column ID Int and IsActive Bit. I want to update bit value. If bit is true then false and if bit is flase then true.

For This I have used below query and its works fine but is there any other way to do this task.

Update  Table_1  set IsActive = Case when IsActive = 0 then 1 Else 0 End

Thanks, Hitesh Paghadal

I don't think the alternative is all that different. – Felix Pamittan May 23 '16 at 07:20 — Felix Pamittan, May 23 '16 at 07:20
What is the problem with your solution ? – sagi May 23 '16 at 07:24 — sagi, May 23 '16 at 07:24
There is no any problem with current solution. – Hitesh May 23 '16 at 09:00 — Hitesh, May 23 '16 at 09:00

score 2 · Answer 1 · edited May 23 '17 at 12:08

2

Duplicate of Boolean 'NOT' in T-SQL not working on 'bit' datatype? which gives the answer "col = ~ col" as the XOR operator - it also illustrates every other method of doing it.

edited May 23 '17 at 12:08

Community

answered May 23 '16 at 07:23

PhillipH

1 Answers1