How to insert data of one Table to Another Table in Sql Server | ASPMANTRA | Asp.Net,MVC,AngularJs,Jquery,Javascript,Sql Server AND WCF 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.

Post a Comment

[blogger]

MKRdezign

Contact Form

Name

Email *

Message *

Powered by Blogger.
Javascript DisablePlease Enable Javascript To See All Widget