Toggle a Bit Value


 
 --Toggle a bit type value with ^ (Bitwise Exclusive OR):

CREATE TABLE test (id int, Col1 INT );
GO
INSERT into test VALUES (1,1 ), (2,0 ), (3,1 ), (4,0 ), (5,1 ),(6,null);
 
SELECT * FROM test ;
--SELECT *, Col1^1 FROM test ;

Update test
Set Col1=Col1^1
                 

SELECT * FROM test ;

DROP TABLE  test ;


 
Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s