what is cursor?why we will go to cursor?advantages &disadvantages of cursors?
Answer Posted / 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 View All Answers
What is user-defined inline table-valued function?
What is the difference between varchar and varchar types?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What are secondary xml indexes?
Tell me about pre-defined functions of sql?
How do I determine how many instances of sql server are installed on a computer?
Define a cross join?
How to create a login account in ms sql server to access the database engine using "create login" statements?
When is update_statistics command used?
Does index speed up select statements?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What are out-of-range errors with date and time literals?
Can you please differentiate between a primary key and a unique key?
What is the difference between rank and dense_rank?
How many types of dimensions are there and what are they? : sql server analysis services, ssas