How to insert data of one Table to Another Table in Sql Server - Free Asp.Net,MVC,AngularJs,Jquery,Javascript,Sql Server,WCF,Entity framework snippets and tutorial

How to insert data of one Table to Another Table in Sql Server

Introduction: In this post I will explain how we can insert the Data of one Table to Another Table in same Database in Sql Server.
Description:
 In the previous post i have explained How to find 2nd, 3rd and N highest salary in Sql Server from Employee Table.
select * into Copy table_Name from Table_Name

OR

select * into DATABASE NAME.TABLE NAME from DATABASE NAME.TABLE NAME

Here Copy table_Name denotes that Table in which you want to copy the Table Data.
Table_Name denotes the Table of which want to copy the Data.

Example:

select * into COPY_DETAIL from dbo.BOOK_DETAIL
OR
select * into Testing.dbo.COPY_DETAIL from Testing.dbo.Emp_salary


You see a Table name COPY_DETAIL will Created in Database.

Is it helpful?

If yes post your comment to admire my work. You can like me on Facebook, Google+, Linkedin and Twitter via hit on Follow us Button and also can get update follow by Email.

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