what is cursor?why we will go to cursor?advantages &disadvantages of cursors?
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 is set nocount on and what is set nocount off?
What is attribute hierarchy? : sql server analysis services, ssas
How to write a query with a left outer join in ms sql server?
What are the requirements to use odbc connections in php scripts?
How get current date in SQL server 2000
4 Answers Cap Gemini, Polaris,
How can I tell if sql server is 32 or 64 bit?
What is field in algebra?
What is trigger ?
what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?
How do I find sql server instance name?
logshipping is Any difference 2000 and 2005?
We create an index to fast the search. How it fast the query? Do we write any special keyword with query?