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 27, 2008 at 5:21 pm

    #918095

    Have you tried

    INSERT INTO [newdb].dbo.[ta_news]

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


    Shamless self promotion - read my blog http://sirsql.net