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
What is the importance of a recovery model?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What is linked report?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
How will you monitor replication latency in transactional replication? : sql server replication
What are the disadvantages of primary key and foreign key in SQL?
What is stored procedures?
Explain optimistic and pessimistic concurrency?
How to move database physical files in ms sql server?
What is the difference between varchar and nvarchar?
What is collation?
Explain stored procedure?
can a database be shrunk with users active? : Sql server administration
What is not null constraint?