Copy all rows from one Table to another in SQL Server using Query

Refer:

1. 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