da-zero (10/29/2010)
Iulian -207023 (10/29/2010)
It still remains unknown to me why SQL Server ignores the + in =+ instead of giving a syntax error.
If I understand correctly, it is not actually a syntax error. As someone else stated, the plus is a unary operator: @a = (+@b). To put in perspective, if the statement was @a =- @b-2, then @a now becomes 21, essentially @a = - (-21).
Hope that helps.
EDIT: Sorry, didn't realise there were more posts that have already explained this. Ignore at your own will.