Post reply

Need to move data to another table

  • July 24, 2005 at 9:09 pm

    #165430

    I need to copy the data from four columns in tableA, and create a new table and insert the data that i copyed from tableA into new tableB. This is not a temp table.

    I have looked through the template in analyzer and i do not see anything that will copy data from one table and create another table to insert it into, however, i am not going to try this one without a little help.

    I need some help on this one, or a site that explains how to do what i am tring to do.

    Thanks.

    Erik...

    Dam again!

  • July 25, 2005 at 5:08 am

    #576709

    Hi Erik,

    Seems to me as though you just need to use a simple SELECT INTO statement.  Try the following:

    SELECT Col1, Col2, Col3, Col4 INTO TableB

    FROM TableA

    This creates a permanent table in your database, and the copied columns will have the same data type as the source table.

    Hope this helps,

    Phil

  • July 25, 2005 at 7:14 am

    #576749

    Ok, Thanks..

    Thanks alot!

    Dam again!

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

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