What are the disadvantages/limitation of the cursor?

 Posted by Syedshakeer on 8/24/2009 | Category: Sql Server Interview questions | Views: 5368
Answer:

Cursor requires a network roundtrip each time it fetches a record, thus consume network resources.
While data processing, it issues locks on part of the table, or on the whole table.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response