Re: Multiple Recordset from a Stored Procedure


"Terry Kreft" <terry.kreft@xxxxxxxxx> wrote in message
news:bfycnQAA5ooVzgXeSa8jmw@xxxxxxxxxxxxxx
> Say you have a stored procedure in SQL Server which looks like this

I am absolutely intrigued by this technique. Seems to me that it might
provide a substantial performance benefit. Any chance you might know where
I can find an example that uses an SP in Oracle to create multiple
recordsets like that?

Randy Harris

.

Relevant Pages

  • Re: ADO stored proc
    ... to know how to access a SQL Server stored procedure using vbscript ... I've looked at vbscript books and sql server books on ... I don't like this technique since: ...
    (microsoft.public.scripting.vbscript)
  • VB.NET databind to drop down list
    ... I have a stored procedure in SQL Server that returns a list of names that I ... would like to bind to a drop down list. ... Prev by Date: ...
    (microsoft.public.dotnet.general)
  • calling stored procedure in ms sql server?
    ... how do i use the perl dbi module to call stored procedure in ms sql server? ... Prev by Date: ...
    (perl.dbi.users)
  • Stored Procedure
    ... I have a stored procedure on the SQL server - ... I created a Access database linking some tables from the database on the ... How can I execute the stored procedure from Access. ... Prev by Date: ...
    (microsoft.public.access.reports)
  • Visual Studio 2003 to SQl Server 2000
    ... Is it possible to debug a stored procedure in SQL Server 2000 from VS 2003? ... Smith ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)