I want to used the below query to transfer the data from old db to new db. But it's failed.


-- The below doesn't work. (content is blank)
use newdb

DECLARE @val BINARY(16)
SELECT @val=TEXTPTR([Content]) FROM [olddb].dbo.[ta_news]
WHERE 1=1
AND [Id] IN (100000000795)
ORDER BY [Id]

WRITETEXT [ta_news].[Content] @val (SELECT [Content] FROM [olddb].dbo.[ta_news] WHERE [Id] IN (100000000795))


-- The below can let me to write the data successfully. But it's not my purpose.
WRITETEXT [ta_news].[Content] @val N'new content'


So does anybody can give suggestion on this? So that I can transfer the data from old db to new db.

Thanks,

Benny Ng