clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2591607 fiddles created (45731 in the last week).

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
 hidden batch(es)