Tags

links:
http://stackoverflow.com/questions/25969/sql-insert-into-values-select-from
http://www.w3schools.com/sql/sql_select_into.asp

summary:
– INSERT INTO table1 ( column1 )
SELECT col1
FROM table2

– INSERT INTO table_name (column1, column2, column3,…)
VALUES (value1, value2, value3,…)

– SELECT LastName,FirstName
INTO Persons_Backup
FROM Persons

Advertisements