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