แชร์ผ่าน


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.

|=

|= (Bitwise OR EQUALS)

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 

image