declare @r bigint
select @r = isnull(@r,col) & col
from tab

select @r

------解决方案--------------------
SQL code

DECLARE @A INT
SET @A = 2147483647

SELECT @A = (@A & 求与字段名)
FROM 表名


PRINT @A