Sql Server: Insert all records of table to another existing table - Free Asp.Net,MVC,AngularJs,Jquery,Javascript,Sql Server,WCF,Entity framework snippets and tutorial


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.


 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



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.

Share this

Share on FacebookTweet on TwitterPlus on Google+


EmoticonEmoticon