How do we return a record set from a Stored Procedure in SQl
server 2000?
Answer Posted / sandeep modapathi
using cursor datatype
declare an output data type
@my_cursor CURSOR VARYING OUTPUT
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Do you know what is normalization of database? What are its benefits?
How do I port a number to sql server?
What is 1nf normalization form?
how you can move data or databases between servers and databases in sql server? : Sql server administration
Explain the difference between function and stored procedure?
What are the purposes and advantages stored procedure?
What is the recovery model?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What is an example of a foreign key?
How will you decide the active and passive nodes?
what are isolation levels? : Sql server database administration
What is bulkcopy in sql?
Can you explain different types of joins?
What is the difference between functions and stored procedures?
What is the Difference Between Primary and Foreign Key?