Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Comparing the values in 2 tables
Message
From
02/04/2009 12:21:29
Naomi Nosonovsky
Wisconsin, United States
 
 
To
02/04/2009 11:32:16
Daniel Aldridge
E.K. Aldridge
Baton Rouge, Louisiana, United States
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Comparing the values in 2 tables
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01392746
Message ID:
01392760
Views:
40
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
Previous
Reply
Map
View

Click here to load this message in the networking platform