Interested to Buy Any Domain ? << Click Here >> for more details...
How do we return a record set from a Stored Procedure in SQl
server 2000?
- 3 Answers
- 6547 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
What do you understand by physical_only option in dbcc checkdb?
how to use DTS package in 2000,2005,2008 in sql server
How do I run sql server 2014?
Tell me something about security and sql azure?
What is the difference between index seek vs. Index scan?
What are the triggers in sql?
How to enable tcp/ip protocol on a sql server?
What are the types of lock supported by ?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What is the default schema of your login session in ms sql server?
Is it possible to call a stored procedure within a stored procedure?
How to drop an existing stored procedure in ms sql server?
What are the main sources of data?
What is spid in sql server profiler?
Will count(column) include columns with null values in its count?
