Posted by John Bell on 09/16/05 23:02

Hi

You should know this when you program your data access routines and a
recordset needs to be declared to hold the resultset. If the parameters are
input/output/result then they need to be declared accordingly. You may look
at the syscolumns table that has a isoutparam column that will determine if
a parameter is an output parameter.

John
<wackyphill@yahoo.com> wrote in message
news:1126884177.488723.219470@g43g2000cwa.googlegroups.com...
> Using ADO.NET Or regular queries on SQL Server, is there a good way of
> determining if a Stored Proc will be returning a result set or if it is
> a non-query that does all I/O through parameters?
>
> Thanks.
>

• Next in forum: Re: Best way to tell if a SP is a query Programatically
• Prev in forum: Re: Best way to tell if a SP is a query Programatically
• Thread view: Re: Best way to tell if a SP is a query Programatically

[Reply to this message]