MS-SQL Insert Into Select

The INSERT INTO SELECT statement copies data from one table and inserts it into an existing table.
INSERT INTO table2 Select * from table1
INSERT INTO person (Name, Country) Select Name, Country from Suppliers