How do we return a record set from a Stored Procedure in SQl
server 2000?
- 3 Answers
- 5395 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
how to invoke a trigger on demand? : Sql server database administration
How many databases can we create in a single server?
What do you understand by replication in sql server?
What sql server means?
Can you get second highest salary from the table?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
What command would you use to create an index?
How you provide security to cube? : sql server analysis services, ssas
Explain what is the main purpose of having conversation group?
Explain the difference between primary keys and foreign keys?
What is report server project?
What is the benefit of normalization?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
How many replicas are maintained for each sql azure db?
please differentiate between delete and truncate?
