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.
I have created table Employee and insert some dummy records. I want to insert records of this table into another table NewEmployee.
Insert into table_name
Select column1, cloumn2 from table_name
Insert into dbo.NewEmployee
Select Name,Phone,Salary,Manag_Id from Employee
What do you think about this article?
If you found this article useful, please share and follow on Facebook, Twitter, Google Plus and other social media websites. To get free updates subscribe to newsletter. Please put your thoughts and feedback in comments section.