Stored procedure that returns an empty resultset as well as a resultset when it shouldnt
- From: "Andy B." <a_borka@xxxxxxxxxxxxx>
- Date: Tue, 23 Jun 2009 17:36:17 -0400
I have the following stored procedure that is supposed to return a resultset
based on Title if it can't find the same thing based on ItemID. It will then
update the row if it is found and return the updated values with output. If
either fail, it returns the existing row based on ItemID and ModuleID. The
problem is when the catch block is entered and a resultset generated, I have
an empty resultset at the beginning of my IDataReader (VB.NET). Is there any
way to get rid of the null/empty resultset? I have a sence that it is coming
from the updates output clause.
.
- Follow-Ups:
- Re: Stored procedure that returns an empty resultset as well as a resultset when it shouldnt
- From: Robert Lakinski
- Re: Stored procedure that returns an empty resultset as well as a resultset when it shouldnt
- From: Erland Sommarskog
- Re: Stored procedure that returns an empty resultset as well as a resultset when it shouldnt
- Prev by Date: RE: Wanted: Discussion on MSSQL Internals Interview Qustions
- Next by Date: Re: Wanted: Discussion on MSSQL Internals Interview Qustions
- Previous by thread: pseudo code to convert decimal to boolean and vice versa
- Next by thread: Re: Stored procedure that returns an empty resultset as well as a resultset when it shouldnt
- Index(es):
Relevant Pages
|
