How do i compare the Tables

Question

Post reply

How do i compare the Tables

SAT_SQL

Default port

Points: 1465
More actions
June 29, 2009 at 5:21 am

#206101

how do i compar the two diffrence of the two tables having 900000 records
Urgent Query

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 1

Could you be more specific please?

Have a look to BOL for INTERSECT/EXCEPT

Jack Corbett SSC Guru Points: 184394 More actions · Answer 2

In addition to Flo's suggestion, which will work, there are several third-party comparison utilities on the market including RedGate SQLDataCompare and ApexSQL SQLDIff that have evaluation versions so you can try them out.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 3

Jack Corbett (6/29/2009)
In addition to Flo's suggestion, which will work, there are several third-party comparison utilities on the market including RedGate SQLDataCompare and ApexSQL SQLDIff that have evaluation versions so you can try them out.

I always forget these tools. I never needed something like this since now. Hope I remember when the day comes...

Thanks Jack!

Mayank Khatri SSCertifiable Points: 7984 More actions · Answer 4

I would use TableDIff utility that comes with SQL 2005.

Lamprey13 SSCertifiable Points: 6210 More actions · Answer 5

Here is an article writen by Peso that compares several methods:

http://weblogs.sqlteam.com/peterl/archive/2009/06/12/Timings-of-different-techniques-for-finding-missing-records.aspx

SAT_SQL Default port Points: 1465 More actions · Answer 6

Hi All

This my sution

there are two tables i am mentioning , but there is 900000 records ,

TABEL-1

ID VALUE USER

123 500 rama

TABEL-2

ID VALUE USER

123 500 soma

Question:

In Table 1, tabel 2, the user name has been changed , can u please tell that how can i find this effected records in huge.

Regards

sateeesh

WayneS SSC Guru Points: 95461 More actions · Answer 7

SAT_SQL (6/29/2009)
Hi All
This my sution
there are two tables i am mentioning , but there is 900000 records ,
TABEL-1
ID VALUE USER
123 500 rama
TABEL-2
ID VALUE USER
123 500 soma
Question:
In Table 1, tabel 2, the user name has been changed , can u please tell that how can i find this effected records in huge.
Regards
sateeesh

Sateeesh,

Did you follow Flo's recommendation to read BOL about the INTERSECT / EXCEPT operators? Because what follows uses them.

select ID, Value, USER from [TABEL-1]

EXCEPT

select ID, Value, USER from [TABEL-2]

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

SAT_SQL Default port Points: 1465 More actions · Answer 8

Wayne

sorry it is not showing the effected records

Regards

sat_sql