Skip to content

Instantly share code, notes, and snippets.

@gdzierzon

gdzierzon/database_update_script_idempotent_external_dependency.sql

Created March 4, 2019 07:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gdzierzon/80b448e480001284b67f9649953d29a6 to your computer and use it in GitHub Desktop.
Save gdzierzon/80b448e480001284b67f9649953d29a6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
database_update_script_idempotent_external_dependency.sql
-- the following external database with new prices should have ben created before execution of this script
/*
CREATE TABLE tmpProductPrices
(
ProductId int
, Price number(10,2)
)
*/
UPDATE p
SET p.Price = tmp.Price
FROM Products AS p
INNER JOIN tmpProductPrices as tmp
ON p.ProductId = tmp.ProductId
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment