Inserting data from one table to another RRS feed

  • Question

  • Hello

    I am using this type of query 

    Insert into ....select * from...... 

    to move data from one table to the another table in the same database and the way i know I will have to make the structure of the destination table as the source one first after that we can run this query.

    Now my question is that is there any query which can be helpful in getting the data into the destination table without making the structure?


    I am trying to move the all the columns from various source tables into the one destination table at once . So how shd i accomplish this.


    Tuesday, March 15, 2011 9:12 PM


  • SELECT *

    INTO Destination_Table





    this will take care of your issue

    Thanks, Cool Mind -- If you find my answer helpful, please mark it as Answer.
    • Proposed as answer by Naomi N Wednesday, March 16, 2011 1:08 AM
    • Marked as answer by KJian_ Monday, March 21, 2011 8:41 AM
    Tuesday, March 15, 2011 9:20 PM