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 difference RDBMS and Graph Database?

625


What are the differences between substr and charindex in sql server.

493


Explain alternate key, candidate key and composite key in sql server?

517


what is a transaction and what are acid properties? : Sql server database administration

522


What is the difference between count () and rowcount ()?

518






Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1427


What do you understand by triggers and mention the different types of it?

479


What is normalization of database? What are its benefits?

515


What are Spatial data types in SQL Server 2008

552


What is recompile sql server?

563


Explain how would you store your query in an SSRS report or a Database server?

88


How many instances per computer are there in sql server 2000?

578


List types of tables in SQL Azure?

102


You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

532


How to automatically create a log when an exception is being received into SQL Server?

731