This is an example of a database update script that is not idempotent.

database_update_script_not-idempotent.sql

--this code increases the price of all products
--in the category by 20% each time the script is run
--The result of the script is different each time the script is run.

UPDATE Product
SET Price = Price * 1.2
WHERE CategoryId = 3001