add-equals-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs	monikerRange
+= (Addition Assignment) (Transact-SQL)	+= (Addition Assignment) (Transact-SQL)	rwestMSFT	randolphwest	03/16/2017	sql	t-sql	reference	+= +=_TSQL	+= (add equals) compound operators, += assignment operators, += augmented operators, +=	TSQL	>= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqldb-mi-current||=fabric

+= (Addition Assignment) (Transact-SQL)

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

Adds two numbers and sets a value to the result of the operation. For example, if a variable @x equals 35, then @x += 2 takes the original value of @x, add 2 and sets @x to that new value (37).

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

expression += expression  

[!INCLUDEsql-server-tsql-previous-offline-documentation]

Arguments

expression
Is any valid expression of any data type in the numeric category except the bit data type.

Result Types

Returns the data type of the argument with the higher precedence. For more information, see Data Type Precedence (Transact-SQL).

Remarks

For more information, see + (Addition) (Transact-SQL).

See Also

Compound Operators (Transact-SQL)
Expressions (Transact-SQL)
Operators (Transact-SQL)
+= (String Concatenation Assignment) (Transact-SQL)