|
|
posted on April 27, 2011 06:01
Syntax:
SELECT field1 [ , field2 [ , ... ] ] INTO newtable FROM source
field1
Is a parameter that specifies the list of the fields that are to be retrieved.
newtable
Is the name of the table the data is to be sent to.
source
Is the name of the table the data is to be retrieved from.
The SELECT INTO statement is used to create a make-table query. It is especially useful for making backup copies of tables and reports, or for archiving records.
Example:
SELECT * INTO Customers_Backup FROM Customers;
There are currently no comments, be the first to post one!