Question: how to copy data from one table to another in sql server using query?
Answer: INSERT INTO SELECT requires that data types in source and target tables match. The existing records in the target table are unaffected.