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
Explain primary key in sql server?
How to provide values to user defined function parameters?
What is lookup override?
Can you please explain the difference between function and stored procedure?
How to change the ownership of a schema in ms sql server?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What is data compression? : sql server database administration
Do you know what are the steps to process a single select statement?
Can we store videos inside the sql server table?
What triggers long term care?
What is ems sql management studio? : sql server management studio
between cast and convert which function would you prefer and why?
Can you edit the .rdl code associated with a linked report?
What are some examples of schemas?
What are the acid properties?