请问这个存储过程该怎么改

[tiantianbulaikan]

CREATE PROCEDURE sp_GetIDByNum
(
@beginnum int,
@count int
)
AS

select top @count * from FilingDomainInfo where ID not in (select top @beginnum ID from FilingDomainInfo)

GO

服务器: 消息 170，级别 15，状态 1，过程 sp_GetIDByNum，行 8
第 8 行: '@count' 附近有语法错误。
服务器: 消息 170，级别 15，状态 1，过程 sp_GetIDByNum，行 8
第 8 行: '@beginnum' 附近有语法错误。

[wenjief]

CREATE PROCEDURE sp_GetIDByNum
(
@beginnum int,
@count int
)
AS

exec('select top' + @count + ' * from FilingDomainInfo where ID not in (select top' + @beginnum + 'ID from FilingDomainInfo) ')

GO

[pt1314917]

CREATE   PROCEDURE   sp_GetIDByNum 
@beginnum   int, 
@count   int 
AS 
	declare @sql varchar(1000)
	set @sql='select top '+cast(@count as varchar)+' * from   FilingDomainInfo   where   ID   
		not   in   (select   top  '+cast(@beginnum as varchar)+' ID   from   FilingDomainInfo)'
	exec(@sql)

[zdliang]

感觉像是个分页的测试存储过程，呵呵。top 后面没有办法跟变量的，拼sql语句吧。或者用临时表加SET ROWCOUNT 吧