UPDATE Table SET value=(22,55,99) WHERE id IN (2,5,9)
所以id = 2的行,value设置为22.而id = 5的行,value设置为55.等等.
update t set value = a.value from Table as t inner join (values (22,2),(55,5),(99,9) ) as a(id,value) on a.id = t.id
对我来说,这是最优雅的方式,它也很容易实现(如果你愿意,可以添加更多列)
