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 -&=, ^=,|=
bitwise operators -&=, ^=,|=
For example
Declare @number int
Set @number = 10
--using Compound assignment operator
Set @number+=200
Select @number as MyResult
Go
Set @number = 10
--using Compound assignment operator
Set @number+=200
Select @number as MyResult
Go
No comments:
Post a Comment