Posted by Erland Sommarskog on 05/23/06 00:40

Wael (sedky@rocketmail.com) writes:
> Thanks for your response. My ultimate goal is to return all the rows
> not just one. Is that doable?

Yes, that's a very normal thing to do.

> Also even with the select statement, the results are not accessible to
> ADO.Net even though I can see them in the query analyzer.

So how does your ADO .Net code look like?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: eternal lock?
• Prev in forum: Re: My boss beats me
• Thread view: Re: Returning multiple rows from a stored procedure

[Reply to this message]