Opérateurs d'assignation composés...
Ils sont maintenant disponibles avec SQL Server 2008.
Operator |
Link to more information |
Action |
+= |
+= (Add EQUALS) |
Adds some amount to the original value and sets the original value to the result. |
-= |
-= (Subtract EQUALS) |
Subtracts some amount from the original value and sets the original value to the result. |
*= |
*= (Multiply EQUALS) |
Multiplies by an amount and sets the original value to the result. |
/= |
/= (Divide EQUALS) |
Divides by an amount and sets the original value to the result. |
%= |
%= (Modulo EQUALS) |
Divides by an amount and sets the original value to the modulo. |
&= |
&= (Bitwise AND EQUALS) |
Performs a bitwise AND and sets the original value to the result. |
^= |
^= (Bitwise Exclusive OR EQUALS) |
Performs a bitwise exclusive OR and sets the original value to the result. |
|= |
Performs a bitwise OR and sets the original value to the result. |
tous les détails sont ici : https://msdn.microsoft.com/en-us/library/cc645922(SQL.100).aspx