Как копировать данные типа Image?

CREATE PROCEDURE Example AS
 
Declare @id int, @NewID int
Declare @ptrval VARBINARY(16), @Newptrval VARBINARY(16)
 
Set nocount on
 
--Destination Table
--Create Table TempWithImg([ID] int IDENTITY, OwnerID int NULL, поля,поля,поля...,myImage image NULL)
--Source Table
--Create Table OwnersExtendedInfo([ID] int IDENTITY, OwnerID int NULL, поля,поля,поля...,BinaryContents image NULL)
 
Declare curMain CURSOR SCROLL READ_ONLY For Select [ID] from OwnersExtendedInfo
Open curMain
 
Fetch First From curMain INTO @Id
 
WHILE @@FETCH_STATUS = 0 BEGIN
   Insert Into TempWithImg(OwnerID,поля,поля,поля...,myImage) select OwnerID,поля,поля,поля...,'' from OwnersExtendedInfo where [ID] = @Id
   set @NewID = @@IDENTITY
-- Обязательно хоть что-то, кроме NULL записать в поле myImage, чтобы был валидный поинтер... 
   SELECT @Newptrval = TEXTPTR(myImage) from TempWithImg where [ID] = @NewID 
   SELECT @ptrval = TEXTPTR(BinaryContents) from OwnersExtendedInfo where [ID] = @Id
 
   if TEXTVALID('OwnersExtendedInfo.BinaryContents', @ptrval) = 1 and TEXTVALID('TempWithImg.myImage', @Newptrval) = 1
      UPDATETEXT TempWithImg.myImage @Newptrval 0 NULL OwnersExtendedInfo.BinaryContents @ptrval
 
   Fetch Next From curMain INTO @Id
END
 
CLOSE curMain
DEALLOCATE curMain
 
Set nocount off
Return 0
GO

Declare @TextSize int
 
Set @TextSize = @@TEXTSIZE -- по умолчанию 4 KB
Set @@TEXTSIZE = 2147483647 -- это максимум 2 GB.
 
-- тут твои действия по копированию image-данных
 
Set @@TEXTSIZE = @TextSize

---CREATE TABLE t1 (c1 int, c2 text)
 
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
GO
INSERT INTO t1 VALUES (4, NULL)
BEGIN TRAN
DECLARE @ptrval VARBINARY(16)
SELECT @ptrval = TEXTPTR(c2)
FROM t1
WHERE c1 = 4
WRITETEXT t1.c2 @ptrval 'x4'
COMMIT

INSERT INTO t1 VALUES (4, NULL)
UPDATE t1 
    SET c2 = NULL 
    WHERE c1 = 4
DECLARE @ptrval VARBINARY(16)
SELECT @ptrval = TEXTPTR(c2)
FROM t1
WHERE c1 = 4
WRITETEXT t1.c2 @ptrval 'x4'