＋设为首页 ＋添加到收藏夹
例:
declare cursor_name cursor for
select field_name from tabe_name where field_name=@field_name
open cursor_name
fetch next from cursor_name into @temp_name
WHILE @@FETCH_STATUS = 0
?? declare cursor_name1 cursor for--能否再次定义不同游标
....
fetch next from cursor_name into @temp_name
End
close cursor_name
deallocate cursor_name
declare cursor_name cursor for
select field_name from tabe_name where field_name=@field_name
open cursor_name
fetch next from cursor_name into @temp_name
WHILE @@FETCH_STATUS = 0
begin
declare cursor_name1 cursor for select * from 另一个表 where xx=@temp_name
open cursor_name1
fetch next from cursor_name into @xxx
while....
begin
.....
end
close cursor_name1
deallocate cursor_name1
fetch next from cursor_name into @temp_name
End
close cursor_name
deallocate cursor_name
