A blog for Microsoft Technologeis, Articles, Reviews,Best Practices, Upcoming Microsoft Technologies particulary related to Windows Server System and .NET 2.0 and related Discussions. The purpose of this blog is to provide a resource to the quick information that Application Developers,Designer and Architects need on Microsoft's Technologies for developing and integrating these technologies.
"T H E K N O W L E D G E W H I C H I S C O N C E A L E A D I S L O S T"
Monday, May 14, 2012
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