Skip to content

Instantly share code, notes, and snippets.

  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Embed
What would you like to do?
This update script will always result in the same updated values in the database regardless of how many times it is executed.
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