What is Compound Operators in sql server 2008? - Sql server 2008

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
Set @number+=200
Select @number as MyResult
SQL Server 2008 introduces automatic auditing - Sql server 2008
Automatic auditing is a true auditing solution for enterprise customers. STL Trace can be used for satisfying several auditing needs..........
Compression - row-level and page-level compression - Sql server 2008
Data compression is a feature which is used to reduce disk storage space and increase the performance of the query by reducing the I/O operations..........
What is filtered indexes in sql server 2008? - Sql server 2008
Filtered index in SQL Server 2008 is an index WHERE clause. A filtered index is an optimized non-clustered index.........
Post your comment