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
- 3073 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
How data can be copied from one table to another table?
What do you mean by authentication modes in sql server?
What is de-normalization in sql database administration? Give examples?
How to assign new column names in a view?
How to create a simple table to test triggers in ms sql server?
what method you can use to reduce the overhead of Reporting Services data sources?
What is reportserver and reportservertempdb ?
How to provide login information for a new odbc dsn?
How to create an index on an existing table in ms sql server?
How you provide security to cube? : sql server analysis services, ssas
Tell me what is difference between clustered and non clustered index?
What happens if null values are involved in bitwise operations?
Explain the advantages of merge replication?
Detail about query optimizer?
Can a table be moved to different filegroup?
