Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
&= (Bitwise AND assignment) (Transact-SQL)
Applies to: 👁 Image
SQL Server 👁 Image
Azure SQL Database 👁 Image
Azure SQL Managed Instance 👁 Image
Azure Synapse Analytics 👁 Image
Analytics Platform System (PDW) 👁 Image
SQL analytics endpoint in Microsoft Fabric 👁 Image
Warehouse in Microsoft Fabric 👁 Image
SQL database in Microsoft Fabric
Performs a bitwise logical AND operation between two integer values, and sets a value to the result of the operation.
👁 Image
Transact-SQL syntax conventions
Syntax
expression &= expression
Arguments
expression
Any valid expression of any one of the data types in the numeric category, except the bit data type.
Return types
Returns the data type of the argument with the higher precedence. For more information, see Data type precedence.
Remarks
The &= operator is shorthand for using the = and & operators. The following two queries are equivalent.
-- &= operator
DECLARE @bitwise AS INT = 1;
SET @bitwise &= 1;
SELECT @bitwise;
GO
-- = and & operators
DECLARE @bitwise AS INT = 1;
SET @bitwise = @bitwise & 1;
SELECT @bitwise;
GO
Both examples return a result of 1.
For more information, see & (Bitwise AND).
Related content
Feedback
Was this page helpful?