请教一个有关TOP @Num 的问题，多谢！

[dickiesh]

MS-SQL Server 2000 存储过程

我想在存储过程中通过游标提取出前M条记录中的N条记录
这里N=5，M=@UserNum

语句如下：

declare ActResultSet cursor local for select top 5 ActNum, Payment, PasvNum, DealTime from (select top @_iAccount ActNum, Payment, PasvNum, DealTime FROM DealHis where ActNum=@UserNum order by DealTime desc) b order by DealTime

查询分析器提示：'@_iAccount' 附近有语法错误。

[zjcxc]

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)

[zjcxc]

top 后面不能用变量 .

[zarge]

declare @cmd varchar(8000)

set @cmd = 'select top 5 ActNum, Payment, PasvNum, DealTime into ##tmp from (select top ' + cast( @_iAccount as varchar ) + ' ActNum, Payment, PasvNum, DealTime FROM DealHis where ActNum=' + cast( @UserNum as varchar ) + 'order by DealTime desc) b order by DealTime'

exec( @cmd )

declare ActResultSet cursor local for select ActNum, Payment, PasvNum, DealTime from ##tmp order by dealtime

open ...
close ...
deallocate ...

drop table ##tmp

[dickiesh]

多谢zjcxc(邹建) ＆ zarge(鲨猩)
请问
作用域为Global的游标在什么时候释放。