&= (Bitwise AND EQUALS) (Transact-SQL)
Performs a bitwise logical AND operation between two integer values, and sets a value to the result of the operation.
Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.
Returns the data type of the argument with the higher precedence. For more information, see Data Type Precedence (Transact-SQL).