title: How to update bit value in SQL
body: <p>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.</p>
  
  <p>For This I have used below query and its works fine but is there any other way to do this task.</p>
  
  <pre><code>Update  Table_1  set IsActive = Case when IsActive = 0 then 1 Else 0 End
  </code></pre>
  
  <p>Thanks,
  Hitesh Paghadal</p>