Try my app Expense Manager @ google play and amazon store.

Thursday, July 5, 2012

Compound Operators in Microsoft Sql Server 2008

Compound operators feature is enhanced in SQL Server 2008. They are like compound operators in languages like C, C++.

Compound operators are a combination of operator with another operator.

The compound assignment operators are : 
arithmetic operators - +=,-=,*=, /=, %=, and
bitwise operators -&=, ^=,|=

For example

Declare @number int
Set @number = 10
--using Compound assignment operator
Set @number+=200
Select @number as MyResult

No comments:

Post a Comment

Follow by Email

Google+ Badge