what is cursor?why we will go to cursor?advantages &disadvantages of cursors?



what is cursor?why we will go to cursor?advantages &disadvantages of cursors?..

Answer / ramya gurrala

Cursor is a pointer(in c/java).Cursor work with DML and information can be accessed.

Cursor is required to process each row individually for queries which return multiple rows.

Advantages:1)We can do operations on each row.
2)Response time is good.
3)Cursors are faster than the while loop.

Disadvantages:1)Repeated network round trips.
2)Occupies more resources and temporary storage.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is set nocount on and what is set nocount off?

0 Answers  


What is attribute hierarchy? : sql server analysis services, ssas

0 Answers  


How to write a query with a left outer join in ms sql server?

0 Answers  


What are the requirements to use odbc connections in php scripts?

0 Answers  


How get current date in SQL server 2000

4 Answers   Cap Gemini, Polaris,






How can I tell if sql server is 32 or 64 bit?

0 Answers  


What is field in algebra?

0 Answers  


What is trigger ?

7 Answers   Cap Gemini, SQL,


what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?

2 Answers  


How do I find sql server instance name?

0 Answers  


logshipping is Any difference 2000 and 2005?

2 Answers  


We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 Answers  


Categories