operators-transact-sql.md

description	Operators (Transact-SQL)
title	Operators (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/02/2016
ms.prod	sql
ms.prod_service	sql-database
ms.reviewer
ms.technology	t-sql
ms.topic	reference
dev_langs	TSQL
helpviewer_keywords	operators [Transact-SQL], about operators operators [Transact-SQL]
ms.assetid	1fc2de8b-e7e0-4c61-9a02-4776a7d93ab7
author	LitKnd
ms.author	kendralittle

Operators (Transact-SQL)

[!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:::

See also

Operator precedence (Transact-SQL)