SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE dbo.T (i integer PRIMARY KEY);
INSERT dbo.T (i) VALUES (2), (3), (4);
CREATE TABLE dbo.TT (q sql_variant NULL);
3 rows affected

UPDATE T
SET T.i = 1
FROM dbo.TT AS TT;
SELECT * FROM dbo.T;

i

2

3

4

INSERT dbo.TT (q) DEFAULT VALUES;
1 rows affected

UPDATE T
SET T.i += 1
FROM dbo.TT AS TT;
3 rows affected

SELECT * FROM dbo.T;

i

3

4

5