SQL server 2008 Question:
Download Questions PDF

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

Download SQL server 2008 Interview Questions And Answers PDF

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