Skip to content

Instantly share code, notes, and snippets.

@dandye

dandye/merge_matched

Created June 27, 2014 18:37
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 dandye/cf4e624c937682245313 to your computer and use it in GitHub Desktop.
Save dandye/cf4e624c937682245313 to your computer and use it in GitHub Desktop.
Download ZIP
merge_matched
Raw
merge_matched
MERGE table_a AS trg
USING table_b AS src
ON (trg.ID = src.ID)
WHEN MATCHED
THEN UPDATE SET trg.f1 = src.f1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment