SQL server 2008 Question:

Explain Compound Operators in sql server 2008?

Answer:

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

Read All 26 SQL server 2008 Questions
Previous QuestionNext Question
Explain benefits of SQL Server 2008 introduces automatic auditing?Tell me inline variable assignment in sql server 2008 with an example?