Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I know the form
Select * into new_table from old_table
statement. Bur recently I found 2 posts here and here which use it like
SELECT * FROM NhlPlayer
INSERT INTO PlayerBackups
I find nothing in msdn, is that some new syntax or just a fault? I guess the later because
INSERT INTO PlayerBackups
SELECT * FROM NhlPlayer
would work fine.
Both posts are wrong syntax.
I've -1 in the first from SO and left a comment on the second.
Create a table
SELECT * INTO PlayerBackups FROM NhlPlayer
Inserts to an existing table
INSERT PlayerBackups SELECT * FROM PlayerBackups
SELECT *
INTO new_table
FROM old_table
The above creates a new table based off of the source's table structure. new_table, in this example, cannot exist or an error will be raised and the statement will not be committed.
INSERT INTO new_table_must_exist
SELECT *
FROM old_table
In this example, it copies data from old_table to new_table_must_exist. Here new_table_must_exist must already exist, and the data mappings have to be compatible.
