using cursor datatype declare an output data type @my

How do we return a record set from a Stored Procedure in SQl
server 2000?

Question Posted / sandeep modapathi

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

Please Help Members By Posting Answers For Below Questions

What are temporal tables in sql server 2016?

838

What is nolock hint in sql server 2008

1067

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1924

why would you use sql agent? : Sql server database administration

1114

how you can list all the tables in a database?

966

What is a Join and explain its types?

1045

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

941

What is the temp table?

864

How to name query output columns in ms sql server?

915

How to create median function?

151

What is delete query?

895

How to list all user defined functions in the current database?

972

What is an execution plan? How would you view the execution plan?

1012

on line cluster can we make if yes tell me the procedure

1974

What are 3 ways to get a count of the number of records in a table?

1016