Refer:
- How to copy rows from one table to another in SQL Server
You can also refer this SQL Script. I have used table variable here you can use your SQL table in the Query.
DECLARE @Table1 TABLE(ID int, Name VARCHAR(50))
INSERT INTO @Table1 VALUES(1,'Jhon hammond')
INSERT INTO @Table1 VALUES(2,'Suzanne Mathews')
INSERT INTO @Table1 VALUES(3,'Robert Schidner')
DECLARE @Table2 TABLE(ID int, Name VARCHAR(50))
INSERT INTO @Table2
SELECT Id ,Name
FROM @Table1
SELECT * FROM @Table1
SELECT * FROM @Table2