Sql Server: Insert all records of table to another existing table

In this article I am going to explain how to insert all records of table to another existing table in Sql server.

In previous article I have explained how to export multipleDatatables data to excel file using CloseXml in asp.net, how to exportDatatable data to excel using CloseXml in asp.net and how to integrate Facebooklogin in Asp.net MVC website.

 Implementation:

I have created table Employee and insert some dummy records. I want to insert records of this table into another table NewEmployee.

Syntax:

Insert into table_name

Select column1, cloumn2 from table_name

Example:

Insert into dbo.NewEmployee

Select Name,Phone,Salary,Manag_Id from Employee