Home Forums SQL Server 2005 SQL Server 2005 General Discussion The question related to WRITETEXT and UPDATETEXT, I want to update the content from old db to new db. RE: The question related to WRITETEXT and UPDATETEXT, I want to update the content from old db to new db.

  • December 28, 2008 at 3:10 pm

    #918209

    Nicholas Cain (12/27/2008)

    Have you tried

    INSERT INTO [newdb].dbo.[ta_news]

    SELECT [ID], [Content] FROM [olddb].dbo.[ta_news] WHERE [Id] = 100000000795

    But this is not supported the nText data type.

    The content after 4000 chars will be cut. 🙁