If you are connected to the SQL Server blogosphere you've probably noticed lots of posts about the next version of SQL Server. One of the improvements of T-SQL is introducing the compound assignment operators (used in lots of programming languages). Most of the posts about this feature mention just the += operator. In fact SQL Server 2008 supports not just the += operator but also the following list of operators:
Subtract and assign -=
Multiply and assign *=
Divide and assign /=
Modulo and assign %=
Bitwise & and assign &=
Bitwise | and assign |=
Bitwise xor and assign ^=
Example:
DECLARE @I INT = 10;
SET @I*=10;
SELECT @I;
-- Result
100