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 shared lock?

647


What is log shipping? Can we do logshipping with SQL Server 7.0 ?

750


What types of Joins are possible with Sql Server?

772


What is index fragmentation in ms sql server?

771


Which tools are available to manage SQL Azure databases and servers?

107






What is the main difference between ‘between’ and ‘in’ condition operators?

797


What is a cube? : sql server analysis services, ssas

715


What does nvl stand for?

708


What are the operating modes in which database mirroring runs?

816


Explain system functions or built-in functions? What are different types of system functions?

724


what is the difference between delete table and truncate table commands? : Sql server database administration

706


what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

785


what authentication modes does sql server support? : Sql server database administration

714


What is a partition function in sql server?

700


How does clustered and non clustered index work?

679