Use of ‘&’ in sql

Accepted answer

Bitwise AND(&) operator works in Binary number format.

Binary value of 4 - 0100

Binary value of 7 - 0111

Each bit of two values is compared, when both the two ends value is 1 result is 1 else it is 0.

0100 & 0111 = 0100 i.e 4

So the result for @A & @B is 4

here A =4 , B = 7 A&B is 4

so 4=4, prints A

here, A =7 , B = 4 A&B is 4

so 4=7, prints B

+1

Thanks Suraj

+5

Here is a good explanation about Bitwise Operator in SQL Server

https://www.c-sharpcorner.com/blogs/bitwise-operators-in-sql

+5