Copy image data type from one table to another

Question

How do you copy an image data type (or varbinary(max)) from one table to another in SQL Server, without having to save the data to a file first?

Answer 1

You select the records from one table and insert into another. As you do it in the same query, the data doesn't leave the database, so you don't have to store it anywhere.

Example:

insert into SomeTable (SomeId, SomeBinaryField)
select SomeId, SomeBinaryField
from SomeOtherTable
where SomeId = 42

Answer 2

You can make at as complex as you like.

I prefer parsing the same field in the same field using a select statement to copy image data from one table to an other.

Update [Database].[dbo].[DataTableA$Attachment]
SET [Store Pointer ID] = (SELECT [Store Pointer ID]
FROM [Database].[dbo].[DataTableB$Attachment]
WHERE [No_] = '35975') WHERE [No_] = '35975'