CASE WHEN my_bit_f = 1 THEN 0 ELSE 1 END
Instead this can be simplified to:
~my_bit_f
MSDN:
http://msdn2.microsoft.com/en-us/library/ms173468.aspx
Showing posts with label bit not bitwise T-sql. Show all posts
Showing posts with label bit not bitwise T-sql. Show all posts
Friday, June 29, 2007
T-SQL bitwise not
Today I stumbled upon a feature in T-Sql that I haven't found before. I was looking for a way to do a bitwise not. I've seen this done with a case statement in a couple of places however it's clumsy and verbose:
Instead this can be simplified to:
MSDN:
http://msdn2.microsoft.com/en-us/library/ms173468.aspx
Instead this can be simplified to:
MSDN:
http://msdn2.microsoft.com/en-us/library/ms173468.aspx
Subscribe to:
Posts (Atom)