Posted by Alex Kuznetsov on 11/07/07 19:26

On Nov 7, 8:00 am, Yash <yas...@gmail.com> wrote:
> Hi,
>
> We are in the process of tuning the performance of our stored procs in
> SQL 2000 and are looking for a tool that would help us in comparing
> the result sets of an old SP and a modified SP. The tool should take
> as input the names of the 2 SPs, a set of parameter values and invoke
> them. Internally it should compare the result sets returned and log/
> display the difference in result sets if any.
> We do not want to compare response time, but want to compare result
> sets just to be sure that the modifications have not changed the
> functionality of the SP.
> The tool should also be able to compare result sets of SPs that give
> out multiple record sets.
>
> Please let us know which tool we can use.
>
> Thanks,
> Yash

we developed exactly that:

http://www.simple-talk.com/sql/t-sql-programming/close-those-loopholes---testing-stored-procedures--/

• Next in forum: SQL 2005 32bit upgrade to 64bit possible?
• Prev in forum: Re: Aggregate Fun (Getting the Max out of MAX)...head scratcher
• Thread view: Re: Tool for comparing result of 2 stored procs

[Reply to this message]