SqlDbx
You are not logged in.
Pages: 1
I did something like this and was expecting a diff, but got two result sets and no diff at all:
cmd diff = old
exec rp_data_my_report
go
cmd diff = new
exec rp_data_my_report_new_version
It works fine with select statements though, just not with stored procs.
Would it be possible to allow procs as well?
Offline
In general it should not matter if it is select or stored procedure.
Does your stored procedure returns exactly one result set?
Offline
You pointed me in the right direction.
SET NOCOUNT ON solved the problem (proc contained INSERTs)
So sorry for the false alarm.
Offline
Pages: 1