what is the cursor life span?

Answer Posted / sumit

The Life Span of the Cursor is till the runtime of the
stored procedure/function in which the cursor is being used
in sql server

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the fillfactor concept in indexes?

532


How do I view a procedure in sql server?

537


what is a correlated sub-query? : Sql server database administration

482


How to use subqueries with the in operators in ms sql server?

565


What is the difference between a fill factor of 100 and 0?

531






What does it mean to normalize a database and why would you do it?

528


Explain “not null constraint” in sql server?

524


Can you tell me about the concept of ER diagrams?

595


How do you know if sql server is running on your local system?

538


What are trace files?

533


what is the sql equivaent of the dataset relation object ?

1567


Can you please differentiate between a primary key and a unique key?

531


Write a sql query to delete duplicate records from a table called table1

586


Explain different types of lock modes in sql server 2000?

521


What is openxml in sql server?

616