What do we mean by @@Fetch_Status in Cursor?

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

@@Fetch_Status function is an in-built Sql-Server function,used when dealing with Cursor object and it checks whether any row is successfully returned from cursor or not.
The value of @@Fetch_Status is undefined before any fetches have occurred on the connection.
It returns 0 if it retrieves rows successfully.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response