sondreb/copy_binary_sql

Last active December 17, 2015 20:38

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/sondreb/5668687.js"></script>
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