An operator or operand is a symbol specifying what action is performed on an expression. SQL Server uses several categories such as Arithmetic operators, Assignment operators, Logical operators and Comparison operators.
New to SQL Server 2008 are Compound Operators which as the name implies are where one operator is combined or compounded with another operator as you see in C++ or C# languages. Below is a chart showing the SQL Server 2008 new compound assignment operands.
Operand
Description
+=
Add And assign
-=
Subtract And assign
*=
Multiply And assign
/=
Divide And assign
%=
Mod And assign
&=
Bitwise & (Bitwise AND) And assign
|=
Bitwise | (Bitwise Logical OR) And assign
^=
Bitwise ^ (Bitwise Exclusive OR) And assign
No Comments