SQL Server 2022

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

create table daten (id int, wert varchar(10));
insert into daten values (1, '1'),(2,'2'),(3,'3');
3 rows affected

select * from daten;


id
wert


1
1

2
2

3
3


;WITH meineParams AS
(
    SELECT  2 as pid, 'zwei' pwert
    union all
    SELECT  1       , 'eins'  
  
)

UPDATE d
SET wert = p.pwert
FROM daten      d
JOIN meineParams  p   ON d.id = p.pid
2 rows affected

select * from daten;


id
wert


1
eins

2
zwei

3
3