Question

How to select data from one table and insert into another in sql server?

Answer 1

Answer:

The INSERT INTO SELECT statement copies data from one table and inserts it into another table.

• INSERT INTO SELECT requires that data types in source and target tables match.
• The existing records in the target table are unaffected.