Post reply

data transfer with in the database

  • January 6, 2009 at 9:33 am

    #127776

    i have two tables with in the same database.i have data in one table i have to transfer that data to another table.for that which transformation we use

  • January 6, 2009 at 11:00 am

    #921975

    If the tables are in the same database, I would recommend opening up a new query in management studio and using a simple insert:

    [font="Courier New"]INSERT MyNewTable (MyCol1, MyCol2)

    SELECT MyCol1, MyCol2 FROM MyOldTable[/font]

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

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