What is Compound Operators in sql server 2008? Explain with an example
Compound operators feature is enhanced in SQL Server 2008. They are like compound operators in languages like C, C++ etc.
Compound operators are a combination of operator with another operator.
The compound assignment operators are - arithmetic operators - +=,-=,*=, /=, %=, bitwise operators -&=, ^=,|=
Declare @number int
Set @number = 10
--using Compound assignment operator
Select @number as MyResult