[Update table from lookup] Update a db table using list of values #sql #database

update_table_from_lookup.sql

update schema.table t
set cola = u.cola
from 
(
    select * from (values
      (1, 'fdjkl'),
      (2, 'reiuuio'),
      (3, 'adfgd')
    ) as t (id, cola)
) u 
where t.id = u.id
;