在select中怎样使用参数指定返回的行数？在线等

[beckhim]

我使用 select top @rows ....,怎么出错？这样的语句应该怎样写？

[zjcxc]

set rowcount @rows
select * from ....
set rowcount 0

[zjcxc]

--或者:
declare @s varchar(8000)
set @s='select top '+cast(@rows as varchar)+' ....'
exec(@s)

[shyyu]

就两种方法：

set rowcount @rows
select * from ....
set rowcount 0


declare @s varchar(8000)
set @s='select top '+cast(@rows as varchar)+' ....'
exec(@s)