Skip to content

Instantly share code, notes, and snippets.

@sondreb

sondreb/copy_binary_sql

Last active December 17, 2015 20:38
Show Gist options
  • Save sondreb/5668687 to your computer and use it in GitHub Desktop.
Save sondreb/5668687 to your computer and use it in GitHub Desktop.
Download ZIP
Copy (binary) data between columns of two different tables in the same database.
Raw
copy_binary_sql
UPDATE
Table1
SET
Table1.OverlayImage = T2.BinaryImage
FROM
Table1 T1
INNER JOIN
Table2 T2
ON
T1.ID = 45 AND T2.ID = 20
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment