Hello,

it's worth to be mentioned that ++ and -- operators don't exist in TSQL. The following example code:

declare @ int = 1, @j-2 int, @k int

Set @j-2 = ++@i

Set @k = @i++

Print @i, @j-2, @k

will be executed without an error, but @j-2 and @k get content "1".

It seems that "++@i" evaluates to "+(+(@i))" ==> "0+0+@i" ==> 1 and "@i++" to "@i+0+0" ==> 1.

Regards,

Klaus Kuehne