By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DECLARE @T table (pk integer PRIMARY KEY, c1 integer NOT NULL);
INSERT @T (pk, c1)
VALUES (1, 0);
DECLARE @v integer;
UPDATE @T
SET @v = c1, c1 = c1 + 10
WHERE pk = 1;
SELECT @v AS pre_update;
UPDATE @T
SET @v = c1 = c1 + 100
WHERE pk = 1;
SELECT @v AS post_update;
| pre_update |
|---|
| 0 |
| post_update |
|---|
| 110 |