Operators (Transact-SQL)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric SQL database in Microsoft Fabric

An operator is a symbol specifying an action that is performed on one or more expressions. The following table lists the operator categories that the SQL Server Database Engine uses.

• :: (Scope resolution)
• = (Assignment operator)
• Arithmetic operators
• Bitwise operators
• Comparison operators
• Compound operators
• Logical operators
• Relational operators
• Set operators: EXCEPT and INTERSECT, UNION
• String operators
• Unary operators: + (positive), - (negative)

• Operator precedence (Transact-SQL)