What are the values that @@Fetch_Status Function return while dealing with Cursor object n Sql-Server?

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

@@Fetch_Status returns 0,-1 and -2 values.
Where
0 - denotes that Fetch is successfully done meaning row is found.
-1 - denotes that Fetch statement failed or the row was beyond the result set.
-2 - denotes that Row which was fetched are not found or missing.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response