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
- 2932 Views
- I also Faced
- E-Mail Answers
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 |
What are the advantages of stored procedure in sql server?
What is side by side migration in sql server?
What is difference between count (*) and count 1?
How do you connect 100 files as a flat file sources in one package of SSIS?
How do SQL server 2000 and XML linked?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What happens when converting big values to numeric data types?
Which are the olap features?
Can I work with several databases simultaneously? : sql server management studio
How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What is a linked server in sql server?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
