Operators (Transact-SQL)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics 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)

Related content

• Operator precedence (Transact-SQL)