How do we return a record set from a Stored Procedure in SQl server 2000?

How do we return a record set from a Stored Procedure in SQl
server 2000?

Question Posted / honeysukumar

3 Answers
5382 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How do we return a record set from a Stored Procedure in SQl server 2000?..

Answer / madhu

SQL Server stored procedures can return multiple record
sets. The following is an example:

CREATE PROCEDURE procCustomerGet
@CustomerID VarChar(5)
AS
SELECT * FROM Customers
WHERE CustomerID =
@CustomerID
SELECT * FROM Orders
WHERE CustomerID =
@CustomerID

Is This Answer Correct ?

2 Yes

0 No

How do we return a record set from a Stored Procedure in SQl server 2000?..

Answer / sd

Select select_list from my_tabel

Is This Answer Correct ?

0 Yes

0 No

How do we return a record set from a Stored Procedure in SQl server 2000?..

Answer / sandeep modapathi

using cursor datatype

declare an output data type
@my_cursor CURSOR VARYING OUTPUT

Is This Answer Correct ?

0 Yes

0 No

Post New Answer