Compound Assignment Operators

Posted: November 21, 2011 in SQL Server 2008

Compound assignment operators help abbreviate code that assigns a value to a column or a variable. The new operators are::

-- Declare variables
DECLARE @i INT = 50;

-- Plus equals
SET @i += 10; 
SELECT @i;

-- Minus equals
SET @i -= 10; 
SELECT @i;

-- Multiplication equals
SET @i *= 10; 
SELECT @i;

-- Division equals
SET @i /= 10; 
SELECT @i;

-- Division equals
SET @i %= 10; 
SELECT @i;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s