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
Can you create a logon trigger in sql server 2005 express edition?
how many layers of tcp/ip protocol combined of? : Sql server database administration
How column data types are determined in a view?
How can you control the amount of free space in your index pages?
Can you please differentiate between a primary key and a unique key?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
List out different types of normalizations in sql server and explain each of them?
Does a sql server 2005 select statement require a from?
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 denormalization? : Sql server database administration
What is the difference between executequery () and executeupdate ()?
What are rows and columns?
what are user defined datatypes? : Sql server database administration
What is data source view or dsv? : sql server analysis services, ssas
What is tcl in sql server?