Testing numeric values with bitwise operators. : Bitwise Operator « Select Query « SQL Server / T-SQL

1. SQL Server / T-SQL
2. Select Query
3. Bitwise Operator

Testing numeric values with bitwise operators.

 

6>
7>     CREATE PROC pr_bitwise
8>     AS
9>     DECLARE @chvHold INTEGER
10>     SELECT @chvHold = 2
11>     IF ( @chvHold & 1) = 1
12>          BEGIN
13>             PRINT 'One Selected'
14>             RETURN
15>          END
16>     IF ( @chvHold & 2) = 2
17>          BEGIN
18>             PRINT 'Two Selected'
19>             RETURN
20>          END
21>     IF ( @chvHold & 3) = 3
22>          BEGIN
23>             PRINT 'Three Selected'
24>             RETURN
25>          END
26>     IF ( @chvHold & 4) = 4
27>          BEGIN
28>             PRINT 'Four Selected'
29>             RETURN
30>          END
31>     GO
1>
2>     EXEC pr_bitwise
3>     GO
Two Selected
1>
2>     DROP PROC pr_bitwise
3>     GO
1>

 

Related examples in the same category