t-sql cursors : does "fetch first from" regenerate the contents of the cursor?
I have a block of someone else's code that does essentially this:

    declare X cursor static for select * from stuff
    open cursor X
    fetch next from X
    while @@fetch_status = 0
    begin
      do stuff
      fetch next from X
    end
    
    fetch first from X
    while @@fetch_status = 0
    begin
      do different stuff
      fetch next from X
    end

To get it out of the way, yes, I know cursors are bad / no longer in fashion / etc.  I didn't write it.  I just have to fix it.  Now to the question:

If the data behind the underlying cursor changes between the first loop and the second loop, could the second cursor loop see different data than the first cursor loop?  Or does the static qualifier prevent that?

t-sql cursors : does "fetch first from" regenerate the contents of the cursor?
===

I have a block of someone else's code that does essentially this:

    declare X cursor static for select * from stuff
    open cursor X
    fetch next from X
    while @@fetch_status = 0
    begin
      do stuff
      fetch next from X
    end
    
    fetch first from X
    while @@fetch_status = 0
    begin
      do different stuff
      fetch next from X
    end

To get it out of the way, yes, I know cursors are bad / no longer in fashion / etc.  I didn't write it.  I just have to fix it.  Now to the question:

If the data behind the underlying cursor changes between the first loop and the second loop, could the second cursor loop see different data than the first cursor loop?  Or does the static qualifier prevent that?
