Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Comparing the values in 2 tables
Message
De
02/04/2009 12:21:29
Naomi Nosonovsky
Wisconsin, États-Unis
 
 
À
02/04/2009 11:32:16
Daniel Aldridge
E.K. Aldridge
Baton Rouge, Louisiane, États-Unis
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Re: Comparing the values in 2 tables
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01392746
Message ID:
01392760
Vues:
39
This message has been marked as a message which has helped to the initial question of the thread.
>I already have this done in Foxpro, scaning and comparing data in 2 tables, but is there a way
>to do this in SQL Server using SQL???
>Basically I have 2 tables that are identical in structure, but the data in one table may not be the same as the other, so I want to find out where the discrepancies are. Is this possible?
>
>Thanks!

Yes. Look at the new EXCEPT keyword in BOL.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform