SQL Server 2008 T-SQL - you learn something new everydayhttp://blogs.technet.com/andrew/archive/2007/11/13/sql-server-2008-t-sql-you-learn-something-new-everyday.aspxIt's the little thing that make you smile.&#160; I am at TechEd this week at an excellent session by Bob Beauchemin on the T_SQL enhancements in SQL Server 2008. He popped up a slide with the += operator which allows you add a number to itself in commonen-USCommunityServer 2.1 SP1 (Build: 61025.2)re: SQL Server 2008 T-SQL - you learn something new everydayhttp://blogs.technet.com/andrew/archive/2007/11/13/sql-server-2008-t-sql-you-learn-something-new-everyday.aspx#2441728Wed, 14 Nov 2007 09:24:48 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:2441728Cristian Lefter, SQL Server MVP<p>Just a little comment, everyone demonstrates the += compound assignment operator. What some people does not know yet is that SQL Server 2008 supports the following list of compound assignment operators:</p> <p>Subtract and assign -= </p> <p>Multiply and assign *= </p> <p>Divide and assign /= </p> <p>Modulo and assign %= </p> <p>Bitwise &amp; and assign &amp;= </p> <p>Bitwise | and assign |= </p> <p>Bitwise xor and assign ^= </p>