What considerations must be there when working with Cursors?

 Posted by Rajesh_Kumar on 1/22/2014 | Category: Sql Server Interview questions | Views: 2373 | Points: 40
Answer:

We have to follow below 5 steps to accomplish Cursors:-

1). Declare cursor.
2). Open cursor.
3). Fetch rows from cursor.
4). Close cursor.
5). Deallocate cursor.

When the cursor is open then it must be closed and then deallocated.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response