An interesting bit-bit computing sharing _mssql SQL Server

Instead of the bool type in SQL Server, a bit type is used to represent the bool value, presumably to conserve storage space.

However, to achieve the reverse operation seems to be troublesome to write, such as the following statements are not possible: Update category set Visible=not visible where id=1, because visible is bit type, not bool type.

A very interesting question has occurred, we found that in SQL Server bit type data-1 can represent 1, so we can change the above statement to:

Update category set visible=visible-1 where id=1

Oh: Of course, you can also write: Update category set Visible = 1-visible where id=1, so there is no-1, only 0 and 1.