The SQL SELECT INTO Statement The SELECT INTO statement copies data from one table into a new table. SELECT INTO Syntax Copy all columns into a new table: SELECT * INTO newtable [IN externaldb] FROM oldtable WHERE condition; Copy only some columns into a new table: SELECT column1, column2, column3, ... INTO newtable [IN externaldb] FROM oldtable WHERE condition; The new table will be created with the column-names and types as defined in the old table. You can create new column names using the AS clause. ________________________________________

The SQL SELECT INTO Statement +2 more

by yash sharma

Stash 0

1 Attachment 4 years ago