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
- 6533 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 happens if strings are casted into wrong code pages in ms sql server?
Explain what is cte (common table expression)?
What is sqlcmd?
What the different components of Replication and what is their use?
How you can get the list of largest tables in a database?
Explain different types of locks in sql server.
Give a example to search fr a string in all stored procedure in sql server.
What is bookmark link in ssrs?
Explain candidate key, alternate key, and composite key?
Does full backup break log chain?
What is acid db?
Tell me something about security and sql azure?
How to provide column names in insert statements in ms sql server?
If user is owning any SQL Objects, can we drop that user
How to select true false based on column value in sql server?
