你可以试试
UPDATE Prepay
SET PrepayTransactionDesc =
CASE
WHEN prepayID = 57770 THEN 'Funded Repeat Voucher 153118'
WHEN prepayID = 57771 THEN 'Funded Repeat Voucher 153119'
WHEN prepayID = nextID THEN 'Next Value'
END
WHERE prepayID in (1,2,4,57770... all your ids here)
602392714
清零编程群