Operators (Transact-SQL)


Updated: June 2, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Arithmetic OperatorsLogical Operators
Assignment OperatorScope Resolution Operator
Bitwise OperatorsSet Operators
Comparison OperatorsString Concatenation Operator
Compound OperatorsUnary Operators

Operator Precedence (Transact-SQL)

Community Additions