kacalapy
asked on
how to compare recordset of 2 stored procs?
I have a vendor deliver a new version of a sql DB. basically we had a vendor take our DB and optimize it totally. the thing is the stored procs need to be sure to return the exact same result set to the application.
how can I test this? any tools, ideas?
how can I test this? any tools, ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Forgot to mention, if you procs have fields like modify_date or timeStamp (any field that is supposed to change during every run), make sure you do not include them in the comparison.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
sorry, line 11 above has ee1 as a folder and it should be ee
ASKER
how can you tell if each cell in the result is the same or not.
also what are the exact steps to get the recordsets out of SQL and how.
i know you can run the proc and get results in SQL studio, but th epaoblem is to compare results or many many procs.