title: What are the examples for @@fetch_status value -2 and -9
body: <p>I need some examples for <code>@@fetch_status</code> values <code>-2</code> and <code>-9</code></p>
  
  <pre><code>   0 = The FETCH statement was successful.
    -1 = The FETCH statement failed or the row was beyond the result set.
  </code></pre>
  
  <p>Here is a sample cursor example</p>
  
  <pre><code> declare @country varchar(50)
   declare cur_country cursor for 
    select name from global
   open cur_country
  
  fetch next from cur_country into @country
    print @@FETCH_STATUS
   while (@@FETCH_STATUS=0)
  begin
  insert into country select @country
  fetch next from cur_country into @country
  end
  
   close cur_country
   deallocate cur_country.
  </code></pre>
  
  <p><code>-2</code>    The row fetched is missing.
  <code>-9</code>    The cursor is not performing a fetch operation.</p>
  
  <p>basically need scenario where <code>@@FETCH_STATUS</code> gives <code>-2</code> 0r <code>-9</code></p>