Interested to Buy Any Domain ? << Click Here >> for more details...
what is cursor?why we will go to cursor?advantages &disadvantages of cursors?
- 1 Answers
- 2933 Views
- I also Faced
- E-Mail Answers
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
Explain the difference between function and stored procedure?
Do you know what are various aggregate functions that are available?
What is the sql profiler?
Explain active/passive and active/active cluster configurations?
What happens if we shrink log file in sql server?
What are the disadvantages of using the stored procedures?
Delete duplicate rows without using rowid.
How to convert a numeric expression from one data type to another?
Is port 1433 secure?
What are the different subsets of sql?
What are the differences between decimal and float in ms sql server?
What is a collation in ms sql server?
What are the types of lock supported by ?
What is openxml in sql server?
Do you know spatial data types - geometry and geography in sql server 2008?
