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
- 6566 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 is the difference between primary key and unique constraints?
What type of Index will get created after executing the above statement?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
What is the purpose of the tempdb database?
How to find the list of fixed hard drive and free space on server?
How do I find query history in sql server?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What are a scheduled jobs?
What is difference between foreign key and unique key?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
How raid can influence database performance?
Explain the different index configurations a table can have?
What is data modeling and Reterminal integrity?
What is normalization? Describe its different types.
what is the primary use of the model database? : Sql server administration
