How to copy one table data into another table directly?

[ComPaCt]

I have One master table where lots of information is already stored but it some kind of overburden has happened now I want to transfer this data to another table, so how do I transfer data from one table to another.

[Breckon]

select * into databasename.<TableName> from (select * from databasename.<TableName>) or you may also try this simple statement for your data transfer select * into t2 from t1 this copy data from table t1 to table t2, Instead of copying, insert rows into another table such that you map user ids with the primary keys of those selected rows.

[ComPaCt]

The table rows already exist, I do not need to insert rows. i.e How to copy one table data into another table directly? I need to 'copy rows' to overwrite what is currently in the existing rows with what is read from the other table rows.

[StudyBoy]

If the table rows already exist, then you do not need to copy anything either. So, if you have table A and table B. Syntax to copy the structure of the one table into another table. syn: select * into newtablename from oldtablename where false conditionTable B has some rows that were copied from table A. The rows in table A have some changes to their content. You now want to update those rows in table B?