Answer the question
In order to leave comments, you need to log in
Can anyone explain the fetch logic to me?
open @cursor
fetch FIRST from @cursor into @str_fetch
while @@FETCH_STATUS = 0
begin
....
fetch NEXT from @cursor into @str_fetch
end
close @cursor
and
open @cursor
fetch NEXT from @cursor into @str_fetch
while @@FETCH_STATUS = 0
begin
....
fetch NEXT from @cursor into @str_fetch
end
close @cursor
I can't understand the difference :(
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question