O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Compound Assignment Operators

Compound operators, a concept that has been around in many other programming languages for a long time, is now available in T-SQL. Compound operators are used when you want to apply an arithmetic operation on a variable and assign the value back into the variable.

For example, the += operator adds the specified value to the variable and then assigns the new value back into the variable. For example

SET @ctr += 1

is functionally the same as

SET @ctr = @ctr + 1

The compound operators are a quicker to type, and they offer a cleaner piece of finished code. Following is the complete list of compound operators:

+=   Add and assign

-=   Subtract and assign

*=   Multiply and assign

/=   Divide and assign

%=   Modulo and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required