Skip to content

Instantly share code, notes, and snippets.

@tdmitch

tdmitch/update_temporal.sql

Last active October 10, 2017 17:36
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 tdmitch/7f35656f7caffbd6c8b301359b61e1cf to your computer and use it in GitHub Desktop.
Save tdmitch/7f35656f7caffbd6c8b301359b61e1cf to your computer and use it in GitHub Desktop.
Download ZIP
Raw
update_temporal.sql
UPDATE dbo.Customers
SET PrimaryContactPersonID = 1029
WHERE PrimaryContactPersonID = 1025
UPDATE dbo.Customers
SET Address = 'Street-level'
WHERE Address = 'Shop 13'
DELETE dbo.Customers
WHERE CustomerID IN (23, 24, 25)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment