The SELECT INTO statement creates the new table by copying schema and other information that is not specific to the actual algorithm.
Syntax :
Example :
select * into dbo.newContacts from [OBXKites] .[dbo] .Contact;
The following SQL statement creates a "Persons_Backup" table with only the persons who lives in the city "Sandnes":
The following example creates a "Persons_Order_Backup" table contains data from the two tables "Persons" and "Orders":
SELECT Persons.LastName,Orders.OrderNo
INTO Persons_Order_Backup
FROM Persons
INNER JOIN Orders
ON Persons.P_Id=Orders.P_Id
Syntax :
SELECT [column]INTO [new table]FROM [existing table]
Example :
select * into dbo.newContacts from [OBXKites] .[dbo] .Contact;
SQL SELECT INTO - With a WHERE Clause
We can also add a WHERE clause.The following SQL statement creates a "Persons_Backup" table with only the persons who lives in the city "Sandnes":
| SELECT LastName,Firstname INTO Persons_Backup FROM Persons WHERE City='Sandnes' |
SQL SELECT INTO - Joined Tables
Selecting data from more than one table is also possible.The following example creates a "Persons_Order_Backup" table contains data from the two tables "Persons" and "Orders":
SELECT Persons.LastName,Orders.OrderNo
INTO Persons_Order_Backup
FROM Persons
INNER JOIN Orders
ON Persons.P_Id=Orders.P_Id