聊聊程式

SELECT *
INTO newtable [IN externaldb]
FROM oldtable
WHERE condition;

SELECT column1, column2, column3, ...
INTO newtable [IN externaldb]
FROM oldtable
WHERE condition;

SELECT Customers.CustomerName, Orders.OrderID
INTO CustomersOrderBackup2017
FROM Customers
LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;

//複製資料表結構
SELECT * INTO new_table_name FROM oldtable
 WHERE 0=1;

參考文章
SELECT INTO 敘述句
SQL SELECT INTO Statement