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
- 6831 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 synonyms?
What is a performance monitor?
What are the types of database schema? : sql server analysis services, ssas
how many bits ip address consist of? : Sql server database administration
What is primary key index?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
Is truncate a dml command?
Why I have to use stored procedures?
How to insert multiple rows with a subquery?
What is a field name?
What is 1nf normalization form?
What is msdb database? : SQL Server Architecture
Can a table have 2 foreign keys?
What do you mean by table and field in sql?
Name some of the open source software that you can use in alternative to SSR?
