RAANA
RAANA
Branch Unspecified
05 Mar 2012

SQL DATABASE: copying data of one table into another table

In C# I want to write the query for copying one table data into another table, can anybody help me?
05 Mar 2012
RAANA
In C# I want to write the query for copying one table data into another table, can anybody help me?
Share the code you've written so far 😀
vinci

vinci

Computer Science
06 Mar 2012
you need sql code
INSERT INTO TABLE2 (COL1, COL2, COL3) SELECT COL1, COL4, COL7 FROM TABLE1
try this


with ADO.Net concepts apply the above query over database table and you get desired results
07 Mar 2012
RAANA
In C# I want to write the query for copying one table data into another table, can anybody help me?
Bulk Copy feature of ADO.NET might help you take a look at that: https://msdn.microsoft.com/en-us/library/s4s223c6.aspx
07 Mar 2012
This is the simplest way to copy a table into another (new) table in the same SQL Server database. This way of copying does not copy constraints and indexes.
select * into <destination table> from <source table>
 
 
Example:
Select * into employee_backup from employee
We can also select only a few columns into the destination table like below
select col1, col2, col3 into <destination table>
from <source table>
 
Example:
Select empId, empFirstName, empLastName, emgAge into employee_backup
from employee
Use this to copy only the structure of the source table.
select * into <destination table> from <source table> where 1 = 2
 
Example:
select * into employee_backup from employee where 1=2
Use this to copy a table across two database in the same Sql Server.
select * into <destination database.dbo.destination table>
from <source database.dbo.source table>
 
Example:
select * into Mydatabase2.dbo.employee_backup
from mydatabase1.dbo.employee
Any one of the following methods can be employed to copy a table into a destination database on a different SQL Server.
1. Data Transformation Service (DTS) – SQL Server 2000.
2. SQL Server Integration Service (SSIS) – SQL Server 2005
3. SQL Server “Export Data” task. – SQL Server 2000/2005
4. Create a linked Server of the destination SQL Server on the source SQL Server and then copy the table. – SQL Server 2000/ 2005.
5. We can also use sp_generate_inserts to generate data insertion scripts and then run the insert scripts.
6. I almost forgot this 😉 you can open the source table , select the row(s), copy (ctrl + C) the row(s), open the destination table and then paste (ctrl + V) the row(s).

Share this content on your social channels -

Only logged in users can reply.