Return a set of records from a stored procedure

[G Patterson]

What is the preferred method of returning a set of records from a stored procedure? Could you please provide a short example?

Thanks ahead of time!

G.

[Paul]

What application r u using ?


------------
G Patterson at 11/14/00 1:34:49 PM

What is the preferred method of returning a set of records from a stored procedure? Could you please provide a short example?

Thanks ahead of time!

G.

[G Patterson]

Back end development using SQL Server 7.


------------
Paul at 11/15/00 7:07:05 AM

What application r u using ?


------------
G Patterson at 11/14/00 1:34:49 PM

What is the preferred method of returning a set of records from a stored procedure? Could you please provide a short example?

Thanks ahead of time!

G.

[Bhanu Borra]

Regarding getting a set of records, you can use the top no.of records u want
to retrieve or set the rowcount option before your select query in u'r stored
procedure.

Thanks
bhanu

------------
G Patterson at 11/14/00 1:34:49 PM

What is the preferred method of returning a set of records from a stored procedure? Could you please provide a short example?

Thanks ahead of time!

G.