Operators

Analytics Platform System (PDW)

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)