dale_berta (7/21/2016)
Interesting. Is this in every release of T-SQL, or could this vary?I only ever use the += with single values on the right-hand side, so I haven't encountered this. Seems like if you have an expression on the right, you should put it in parentheses for clarity, even though they're not actually required.
[spelling]
No, if you look at the precedence rules (as pointed out by Jeff) or even just look at the definition of the syntax of assignments using += it's obvious that the RHS has to be computed before it's used.
Tom