Sponser Link

SQL Server INSERT INTO SELECT By Complete Examples

If you want to copy data from one or more tables to another table then you can write the

INSERT to SELECT statement. But column sequence and type should be same as per destination table.

 INSERT INTO table1
 SELECT col1, col2 , col3 FROM table2
 WHERE your condition;

In above syntax, you can write the select * instead of columns name if schema is same. Here is example of salestransaction table.

 INSERT INTO salesTransaction_History
 SELECT * FROM salesTransaction
 WHERE item_Number='Salt-1';