How to insert rows with structure from one table to another table?

What is the query in SQL Server to insert rows with structure from o开发者_运维问答ne table to another table?

---

A couple ways

SELECT INTO

SELECT 
   field1,
   field2,
   ...
INTO Table1
FROM Table2

INSERT INTO

INSERT INTO Table1
   field1,
   field2,
   ...
SELECT
   field1,
   field2,
   ...
FROM Table2

---

Sounds like you want something like this:

INSERT INTO DestTable (Column1,COlumn2)
   SELECT Column1, Column2
   FROM SourceTable

---

Here is the documentation for the INSERT...EXECUTE statement that will allow you to do what you need.