Advantages and Disadvantages of Cursor?

Answer Posted / ruchita

Adv:cursor is a private sql area in which
row by row operatioms and validations can be done
disadv:resource reqired are more

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between deallocate cursor and close cursor?

713


Why we need to use secondry database file? though, we can do same work using primary database file also.

5760


How do you rebuild an identity column?

542


What are the advantages of using a stored procedure?

556


What are recommended options to be used while using db mirroring? : sql server database administration

568






What is the distinction amongst delete and truncate?

583


You want to implement the many-to-many relationship while designing tables. How would you do it?

555


How will you monitor replication latency in transactional replication? : sql server replication

601


Can you tell me about the concept of ER diagrams?

593


What are acid properties of transaction?

549


What are the benefits and tasks of object explorer? : sql server management studio

605


How many instances per computer are there in sql server 2000?

578


What you can do to delete a table without the delete trigger firing?

517


What are secondary xml indexes?

562


What does truncate do?

531