SQL SELECT INTO Statement
The SELECT INTO Statement
The SELECT INTO statement is most often used to create backup copies of tables or
for archiving records.
Syntax
SELECT column_name(s) INTO newtable [IN externaldatabase]
FROM source
|
Make a Backup Copy
The following example makes a backup copy of the "Persons" table:
SELECT * INTO Persons_backup
FROM Persons
|
The IN clause can be used to copy tables into another database:
SELECT Persons.* INTO Persons IN 'Backup.mdb'
FROM Persons
|
If you only want to copy a few fields, you can do so by listing them after
the SELECT statement:
SELECT LastName,FirstName INTO Persons_backup
FROM Persons
|
You can also add a WHERE clause. The following example
creates a "Persons_backup" table with two columns (FirstName and
LastName) by extracting the persons who
lives in "Sandnes" from the "Persons"
table:
SELECT LastName,Firstname INTO Persons_backup
FROM Persons
WHERE City='Sandnes'
|
Selecting data from more than one table is also possible. The following example creates
a new table "Empl_Ord_backup" that contains data from the two tables Employees and
Orders:
SELECT Employees.Name,Orders.Product
INTO Empl_Ord_backup
FROM Employees
INNER JOIN Orders
ON Employees.Employee_ID=Orders.Employee_ID
|
Want To Be A Web Master?
If you want to be a Web Master, you will have to host your web site with an ISP (Internet Service Provider).
MaximumASP offers seven different configurations of dedicated servers to meet your Windows and .NET hosting needs.
Hosted on our multi-tiered Enterprise Class network, these servers provide the performance, security and reliability
you need to host your high end web sites and applications.
Visit MaximumASP
| 
HOME
Printer friendly page
