DECLARE @src_textptr varbinary(16), @dest_textptr varbinary(16);
SELECT @src_textptr = TEXTPTR( txtfld )
FROM src_tbl
WHERE IDENTITYCOL = 1;

-- Ensure that the text pointer is initialized for the
-- destination table
UPDATE dest_tbl
SET txtfld = ''
WHERE IDENTITYCOL = 2;

SELECT @dest_textptr = TEXTPTR( txtfld )
FROM dest_tbl
WHERE IDENTITYCOL = 2;

-- If the source & destination pointers are NOT NULL , do the copy
-- of the text data from the source table to the destination.
IF COALESCE( @src_textptr , @dest_textptr ) IS NOT NULL
        UPDATETEXT dest_tbl.txtfld @dest_textptr 0 NULL src_tbl @src_textptr;

This page was last updated on May 01, 2006 04:28 PM.