operators-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	ms.custom	helpviewer_keywords	dev_langs	monikerRange
Operators (Transact-SQL)	An operator is a symbol specifying an action that is performed on one or more expressions.	rwestMSFT	randolphwest	07/23/2024	sql	t-sql	reference	ignite-2024	operators [Transact-SQL], about operators operators [Transact-SQL]	TSQL	>=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric

Operators (Transact-SQL)

[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw-fabricsqldb]

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 [!INCLUDE ssdenoversion-md] 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)

Related content

• Operator precedence (Transact-SQL)