SqlDbx Forum

SqlDbx

You are not logged in.

#1 2014-08-18 04:33:09

geo
Member

cmd diff

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

#2 2014-08-18 08:45:47

sqldbxhelp
Administrator

Re: cmd diff

In general it should not matter if it is select or stored procedure.
Does your stored procedure returns exactly one result set?

Offline

#3 2014-08-20 09:01:07

geo
Member

Re: cmd diff

You pointed me in the right direction.
SET NOCOUNT ON solved the problem (proc contained INSERTs)

So sorry for the false alarm.

Offline

Board footer

Powered by FluxBB