Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE

Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE


Method 1 : INSERT INTO SELECT

----Create
Table2 CREATE TABLE Table2(FirstName VARCHAR(100), LastName VARCHAR(100))
 
----INSERT INTO Table2 using SELECT
INSERT INTO Table2(FirstName, LastName)
SELECT FirstName, LastName
FROM Table1
WHERE [id]= 2

----Verify that Data in Table2
SELECT FirstName, LastName
FROM Table2


Method 2 : SELECT INTO 


----Create new table and insert into table using SELECT INSERT
SELECT FirstName, LastName
INTO Table2
FROM Table1
WHERE [id] = 2

----Verify that Data in TestTable
SELECT FirstName, LastName
FROM Table2