SQL - Structured Query Language

Compound Operators

An operator is a symbol specifying an action that is performed on one or more expressions. SQL Server operators can categories into Arithmetic Operators, Assignment Operator, String Concatenation Operator, Comparison Operators, Bitwise Operators, Unary Operators, Compound Operators, Scope Resolution Operator, Logical Operators and SET Operators.

Compound operators are used to execute arithmetic and bitwise operator's operation with a variable that output value should update on the original variable's value.

Symbol	Name	Description
+=	Add EQUALS	To add some value with original variable's value and then update the output on the original variable's value.
-=	Subtract EQUALS	To subtract some value with original variable's value and then update the output on the original variable's value.
*=	Multiply EQUALS	To multiply some value with original variable's value and then update the output on the original variable's value.
/=	Divide EQUALS	To divide some value with original variable's value and then update the output on the original variable's value.
%=	Modulo EQUALS	To divide some value with original variable's value and then update the remainder output on the original variable's value.
&=	Bitwise AND EQUALS	To execute bitwise AND operation with original variable's value and then update the output on the original variable's value.
^=	Bitwise Exclusive OR EQUALS	To execute bitwise exclusive OR operation with original variable's value and then update the output on the original variable's value.
\|=	Bitwise OR EQUALS	To execute bitwise OR operation with original variable's value and then update the output on the original variable's value.

* * * * *

Your Comment To AUTHOR