This update script will always result in the same updated values in the database regardless of how many times it is executed.

database_update_script_idempotent_explicit.sql

UPDATE Product SET Price = 12.95 WHERE ProductId = 1435
UPDATE Product SET Price = 23.70 WHERE ProductId = 1436
UPDATE Product SET Price = 31.95 WHERE ProductId = 1498
...