Binaryworld - How to copy text values from one table to another? This one demonstrat ... [ SQL Server -> T-SQL ]

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;