| title | Operators (Transact-SQL) | ||
|---|---|---|---|
| description | Operators (Transact-SQL) | ||
| author | rwestMSFT | ||
| ms.author | randolphwest | ||
| ms.date | 06/02/2016 | ||
| ms.service | sql | ||
| ms.subservice | t-sql | ||
| ms.topic | reference | ||
| helpviewer_keywords |
|
||
| dev_langs |
|
[!INCLUDE 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 [!INCLUDEssNoVersion] uses.
:::row:::
:::column:::
Arithmetic operators
:::column-end:::
:::column:::
Relational operators
:::column-end:::
:::row-end:::
:::row:::
:::column:::
Assignment operator
:::column-end:::
:::column:::
Scope resolution operator
:::column-end:::
:::row-end:::
:::row:::
:::column:::
Bitwise operators
:::column-end:::
:::column:::
Set operators (EXCEPT and INTERSECT, UNION)
:::column-end:::
:::row-end:::
:::row:::
:::column:::
Comparison operators
:::column-end:::
:::column:::
String Concatenation operator
:::column-end:::
:::row-end:::
:::row:::
:::column:::
Compound operators
:::column-end:::
:::column:::
Unary operators
:::column-end:::
:::row-end:::
:::row:::
:::column:::
Logical operators
:::column-end:::
:::row-end:::