Tool

Question

Post reply

Tool

ramana3327

SSCoach

Points: 19722
More actions
June 11, 2014 at 10:30 am

#294258

Hi,
I am looking for a tool to compare the result sets.
Is there any free tool or Microsoft built in tool that we can use to compare the result sets. Suppose if I change one thing in code and needs to test the am I getting the same result set or not? Instead of doing manually is there any way to compare both result set

Viewing 6 posts - 1 through 5 (of 5 total)

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

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

There is one free built-in tool.

http://msdn.microsoft.com/en-us/library/ms188055.aspx

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Sarah Wagner Hall of Fame Points: 3178 More actions · Answer 2

If you are querying from different servers you can output the result set to file and then use notepad++, this is something I have done for text file comparison in the past.

ramana3327 SSCoach Points: 19722 More actions · Answer 3

No.

I am looking from same server only. But need to test result set for code changes in the Sproc.

Sarah Wagner Hall of Fame Points: 3178 More actions · Answer 4

You could dump results into 2 temp tables and then use Except...

Ed Wagner SSC Guru Points: 287026 More actions · Answer 5

I've done text comparisons on text files using Ultra Compare, but I think that running the results into tables and then comparing the tables is probably the most straightforward approach.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions