Selecting data using bitwise operators. : bitwise operators « Data Types « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Data Types
  3. bitwise operators
Operator    Description 
    &           Bitwise, logical AND    
    ?           Bitwise, logical OR 
    ^           Bitwise, logical exclusive OR   
    ~           Bitwise NOT 
4>
5>
6>
7>     CREATE TABLE tableX (
8>         bitPriced BIT,
9>         bitCredit_checked BIT,
10>         bitAllocated BIT,
11>         bitShipped BIT
12>     )
13>     GO
1>
2>     INSERT tableX (bitPriced, bitCredit_checked, bitAllocated, bitShipped) VALUES (1,1,0,0)
3>     INSERT tableX (bitPriced, bitCredit_checked, bitAllocated, bitShipped) VALUES (1,0,1,0)
4>     INSERT tableX (bitPriced, bitCredit_checked, bitAllocated, bitShipped) VALUES (0,0,0,0)
5>     INSERT tableX (bitPriced, bitCredit_checked, bitAllocated, bitShipped) VALUES (1,1,1,0)
6>     GO

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)
1>
2>     SELECT *
3>     FROM tableX
4>     WHERE bitAllocated ^ bitPriced = 1
5>     GO
bitPriced bitCredit_checked bitAllocated bitShipped
--------- ----------------- ------------ ----------
        1                 1            0          0

(1 rows affected)
1>
2>     DROP TABLE tableX
3>     GO
1>
2>








5.3.bitwise operators
5.3.1.Selecting data using bitwise operators.
5.3.2.Testing numeric values with bitwise operators.
5.3.3.Bitwise NOT (~) Validity Table
5.3.4.Legal Bitwise Operation
5.3.5.Retrieving Index Properties by Using the Bitwise AND (&) Operator
5.3.6.Bitwise AND (&)
5.3.7.Bitwise OR (|)
5.3.8.Exclusive Or (^)
5.3.9.Bitwise NOT (~)
5.3.10.The bitwise_not() Scalar Function
5.3.11.The bitwise_and() Scalar Function
5.3.12.The bitwise_or() Scalar Function
5.3.13.The bitwise_xor() Scalar Function