What are the disadvantages/limitation of the cursor?

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

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