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
- 3049 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 do you rename a table in sql server?
Is oracle faster than sql server?
How to set database to be read_only in ms sql server?
What is 1nf 2nf and 3nf?
What is a primary key?
What is update_statistics command?
What is attribute hierarchy? : sql server analysis services, ssas
How to retrieve field values using mssql_result()?
What is log ldf?
What happens if we shrink log file in sql server?
What are the types of stored procedures in an sql server?
How many categories of data types used by sql server?
Can you pass expressions to stored procedure parameters?
Explain something about security and SQL Azure?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
