Compare 2 Stored Proc Results

Question

Viewing 3 posts - 1 through 2 (of 2 total)

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

dbaker-620086 SSCrazy Points: 2336 More actions · Answer 1

doubtless the RedGate fraternity will have some clever and witty solution to all parameter values

- this is just the simple version from the coal-face

you can use SQLCMD plus FC or WINDIFF or WDCMX

SQLCMD -S mysvr -d mydb -E -Q "exec usp_OLD @p1=123" -o old.txt

SQLCMD -S mysvr -d mydb -E -Q "exec usp_NEW @p1=123" -o new.txt

FC old.txt new.txt

where you can plug-in your sproc names and sample calling values as appropriate

or use C:\Program Files\Support Tools\WINDIFF.exe if you prefer GUI, downloadable from

or (better?)

HTH

Dick

yonision Ten Centuries Points: 1033 More actions · Answer 2

Yes there is!

🙂