Article 3.6.1T : How to copy SQL Data from one table to another table ?
1.
SET NOCOUNT ON
SET STATISTICS TIME ON
INSERT INTO Table_name_one
(
colm1,
colm2,
colm3,
colm4,
colm5
)
SELECT
colm1,
colm2,
colm3,
colm4,
colm5,
FROM Table_name_two
SET STATISTICS TIME OFF
SET NOCOUNT OFF
Note: Before trying this SQL query please take backup of your DB.