Mega Code Archive

 

Categories / MSSQL / Select Query

 

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>