Copy only a few columns from "Suppliers" into "Customers":
Example
INSERT INTO Customers (CustomerName, Country)SELECT SupplierName,...
SQL - INSERT INTO SELECT Syntax
We can copy all columns from one table to another, existing table:
INSERT INTO table2
SELECT * FROM table1;
Or we...
SQL - SELECT INTO Examples
Create a backup copy of Customers:
SELECT *
INTO CustomersBackup2017
FROM Customers;
Use the IN clause to copy the table into...
Subscribe to:
Posts (Atom)
