469,641 Members | 1,129 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,641 developers. It's quick & easy.

Tool for comparing result of 2 stored procs

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

Nov 7 '07 #1
2 3170
On Nov 7, 8:00 am, Yash <yas...@gmail.comwrote:
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...-procedures--/

Nov 7 '07 #2
On Nov 7, 7:00 am, Yash <yas...@gmail.comwrote:
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.
Wouldn't it be nice if such a tool was not even necessary!

Basic Anatomy of Sql Server, part I
What is a stored procedure?
http://beyondsql.blogspot.com/2007/1...er-part-i.html

Basic Anatomy of Sql Server, part II
The unit test as part of the database.
http://beyondsql.blogspot.com/2007/1...r-part-ii.html

Basic Anatomy of Sql Server, part III
What does deferred name resolution really mean?
http://beyondsql.blogspot.com/2007/1...-part-iii.html

www.beyondsql.blogspot.com

Nov 8 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Dave | last post: by
1 post views Thread by Paul R | last post: by
5 posts views Thread by Rob | last post: by
2 posts views Thread by Jared | last post: by
8 posts views Thread by Frank Calahan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.