I run this script:
No I wrap the same script into an anonymous SP block:
- in the standalone script @b was assigned to the initial value of @a
- in the anonymous block @b was assigned to the new value of @a
We'll make multiple SET inside an SP work the same way with a standalone SET.
Note, multiple SET for SP variables should also work the same way.