Из BOL

"& (Bitwise AND)
Performs a bitwise logical AND operation between two integer values.

Syntax
expression & expression

Arguments
expression

Is any valid Microsoft® SQL Server™ expression of any of the data types of the integer data type category. expression is an integer parameter that is treated and transformed into a binary number for the bitwise operation.

Result Types
Returns an int if the input values are int, a smallint if the input values are smallint, or a tinyint if the input values are tinyint
& (Bitwise AND)
Performs a bitwise logical AND operation between two integer values.

Syntax
expression & expression

Arguments
expression

Is any valid Microsoft® SQL Server™ expression of any of the data types of the integer data type category. expression is an integer parameter that is treated and transformed into a binary number for the bitwise operation.

Result Types
Returns an int if the input values are int, a smallint if the input values are smallint, or a tinyint if the input values are tinyint

Examples
This example creates a table with int data types to show the values, and puts the table into one row.

USE master
GO
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'bitwise')
DROP TABLE bitwise
GO
CREATE TABLE bitwise
(
a_int_value int NOT NULL,
b_int_value int NOT NULL
)
GO
INSERT bitwise VALUES (170, 75)
GO

This query performs the bitwise AND between the a_int_value and b_int_value columns.

USE MASTER
GO
SELECT a_int_value & b_int_value
FROM bitwise
GO

Here is the result set:

-----------
10

(1 row(s) affected)
"