Post reply

Copy TEXT and NTEXT fields from table to table

  • November 6, 2002 at 6:40 pm

    #63966

    Hi,

    Is there a way of transferring data from a TEXT field in one table to a TEXT field in a second table within SQL Server? Currently, I'm retrieving the text out of SQL Server using READTEXT to VB then from VB back into SQL Server.

    Thanks in advance,

    Paul

  • November 6, 2002 at 7:20 pm

    #440578

    I believe if the datas lenght in the text field is always under 8000 bytes then you can use INSERT...FROM, also I am pretty sure you can use the SQL READTEXT and WRITETEXT but that is very awkward. The other way is to use DTS to transfer the data, just define two connections and a tranformation to move it.

  • November 7, 2002 at 6:44 am

    #440629

    You can copy these columns from one table to another just like any other datatype just as long as you don't use local variables.

    Simon Sabin

    Co-author of SQL Server 2000 XML Distilled

    http://www.amazon.co.uk/exec/obidos/ASIN/1904347088


    Simon Sabin
    SQL Server MVP

    http://sqlblogcasts.com/blogs/simons

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply