Operators (Transact-SQL)

Applies to: SQL Server Azure SQL Managed Instance

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

Arithmetic operators

Relational operators

Assignment operator

Scope resolution operator

Bitwise operators

Set operators (EXCEPT and INTERSECT, UNION)

Comparison operators

String Concatenation operator

Compound operators

Unary operators

Logical operators

See also

Operator precedence (Transact-SQL)