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
- 6713 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 are the system database in sql server 2005?
What is scrollable cursor?
What are the acid properties?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Explain what is the main purpose of having conversation group?
What is master database? : SQL Server Architecture
Explain sub-query?
What is default constraint?
What do you mean by sql server agent?
Mention the differences between sql server and mysql.
How to check parameter value in stored procedure sql server?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
Explain what is log shipping?
How to list all login names on the ms sql server?
What is SQL Azure?
