如何用唯一值更新表中的列，但不更新所有行，不递增[重复]

你可以试试

UPDATE PrepaySET PrepayTransactionDesc =    CASE     WHEN prepayID = 57770 THEN 'Funded Repeat Voucher 153118'     WHEN prepayID = 57771 THEN 'Funded Repeat Voucher 153119'     WHEN prepayID = nextID THEN 'Next Value'    ENDWHERe  prepayID in (1,2,4,57770... all your ids here)