BitWise Operators in SQL SERVER

Bitwise operators perform bit manipulations between two expressions of any of the data types of the integer data type category.The operands for bitwise operators can be any one of the data types of the integer or binary string data type categories (except for the image data type)

There are three types of BitWise operators

• & (Bitwise AND)  
• ~ (Bitwise NOT) 
• | (Bitwise OR) 
• ^ (Bitwise Exclusive OR)

We will use following table and data to execute our examples

For code and further detail about Bitwise operator. Please visit this blog link

http://shamas-saeed.blogspot.com/2012/05/bitwise-operators-in-sql-server.html

& (Bitwise AND)

~ (Bitwise NOT)

| (Bitwise OR) 

^ (Bitwise Exclusive OR)

..............................................................................

................................................................................\