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
- 6848 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
Explain in details security in SQL azure?
Can we take the full database backup in log shipping?
What is difference between materialized view and view?
What is transactional replication?
Why we should not use triggers?
Does a server store data?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
Explain what is raid and what are different types of raid levels?
What is mean by dml?
How can we check the sql server version?
What is the meaning of resultset type_scroll_insensitive?
How to assign null values to variables or columns?
what are cursors? : Sql server database administration
Define Unique Key?
Who developed sql server?
