How to copy distinct records from one table to another using SQL 2005
Please support our MS SQL advertiser: Programming Forums
 |
I have a table on an offline database having let say 2000 rows and same table on an online database with let say 3000 rows. Now I want to copy just those records (1000) from online database that are not in the offline database table. Also, both tables have same name, same schema etc.
Use differential Backup...
or you can use insert select
like
or you can use insert select
like
insert into table1 values (select distinct a,b,c.. from table2)
BI Developer | LINKdotNET
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
|
Similar Threads
Other Threads in the MS SQL Forum
- how to delete duplicate record in a table by using SQL query (MS SQL)
- SQL 2005 upgrade questions (MS SQL)
- program adds 2 identical records to table (Visual Basic 4 / 5 / 6)
- Hurry! Cheap Private Label ASP.net 2/ColdFusion MX/SQL 2005 Windows Reseller Hosting! (Web Hosting Deals)
- Hurry! Cheap Private Label ASP.net 2/ColdFusion MX/SQL 2005 Windows Reseller Hosting! (Web Hosting Deals)
- sql 2005 to sql 2000 (MS SQL)
- How can I select records randomly from MS SQL Server Table? (MS SQL)
- Cheap ColdFusion/ASP.net 2/SQL 2005 Shared and Reseller Hosting (Web Hosting Deals)
- Print 5 records per table row (see script) (Perl)
Other Threads in the MS SQL Forum
- Previous Thread: How to Insert, Update and Delete objects in Active Directory
- Next Thread: SQL Server newbi... how to get started??
•
•
•
•
Views: 8634 | Replies: 2 | Currently Viewing: 1 (0 members and 1 guests)
Linear Mode
