Answers

Question and Answer:

  Home  SQL server 2008

⟩ Explain Compound Operators in sql server 2008?

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

Set @number+=200

Select @number as MyResult

Go

 146 views

More Questions for you: