• Login

Snippets

27
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;

Posted in: SQL Scripts

Post Rating

Comments

There are currently no comments, be the first to post one!

Post Comment

Name (required)

Email (required)

Website