•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 373,930 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,246 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 4635 | Replies: 2
 |
•
•
Join Date: Sep 2007
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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.
•
•
Join Date: Dec 2006
Location: United States
Posts: 612
Reputation:
Rep Power: 3
Solved Threads: 14
DaniWeb Expert
What are the keys in the table?
•
•
Join Date: Aug 2006
Location: Egypt
Posts: 743
Reputation:
Rep Power: 3
Solved Threads: 53
Master Poster
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)
B.Sc Computer Science, Helwan University
Microsoft Student Partner
Personal blog http://ramymahrous.blogspot.com/
Arabic technical blog http://fci-h-ar.blogspot.com/
English technical blog http://fci-h.blogspot.com/
Microsoft Student Partner
Personal blog http://ramymahrous.blogspot.com/
Arabic technical blog http://fci-h-ar.blogspot.com/
English technical blog http://fci-h.blogspot.com/
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Linear Mode
- 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??
