Even after ten years in sql-server world, you can still find something you didn't know..
I have a field in a table called IsTrue of the type bit. I just want to toggle it, if it's true, set to false and if it's false, set to true.
I was on my way to do a case statement when I realized there is at least to better ways of doing this.
the bitwise NOT operator way
update table set IsTrue = ~IsTrue
the bitwise XOR operator way:
update table set IsTrue = IsTrue^1
Can't believe I didn't know you could do that in SQL Server... =)