Skip to content

Instantly share code, notes, and snippets.

@gdzierzon

gdzierzon/database_update_script_idempotent_explicit.sql

Created March 4, 2019 07:19
Show Gist options
  • Save gdzierzon/918ecefd3798bb68809257d45a9bc1c8 to your computer and use it in GitHub Desktop.
Save gdzierzon/918ecefd3798bb68809257d45a9bc1c8 to your computer and use it in GitHub Desktop.
Download ZIP
This update script will always result in the same updated values in the database regardless of how many times it is executed.
Raw
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
...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment