What is the return type of @@Fetch_Status Function?

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

The return type of @@Fetch_Status is always integer.
In Cursor,we check for @@Fetch_Status as:

While @@Fetch_Status = 0

begin
Fetch Next From cursor_name;
end


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response