+= (Add EQUALS) (Transact-SQL)

+= (Add EQUALS) (Transact-SQL)

Community Content

In this section

Statistics Annotations (0)

Click here to expand

Collapse All

Language Filter

SQL Server 2008 Books Online (November 2009)

+= (Add EQUALS) (Transact-SQL)

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).

Topic link icon Transact-SQL Syntax Conventions

Syntax

expression += expression

Arguments

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

Remarks

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

Result Types

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

Reference

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

Help and Information

Getting SQL Server 2008 Assistance