declare @s varchar(8000)
set @s='declare ActResultSet cursor global for select top 5 ActNum, Payment, PasvNum, DealTime from (select top '+cast(@_iAccount as varchar)+' ActNum, Payment, PasvNum, DealTime FROM DealHis where ActNum=@UserNum order by DealTime desc) b order by DealTime'
exec(@s)
close ...
deallocate ...drop table ##tmp
请问
作用域为Global的游标在什么时候释放。