存储过程中的TOP后跟一个变量会如何？

Create proc getWorkPlan2

@intCounter int

,@lngUserID int

as

select Top 5 lngWorkID,strWorkName,strExecHumanName,strBeginDate

from worklist where lngExecHumanID= @lngUserID

order by lngWorkID desc

现在想将这里的Top　5 改为变量· Top @intCounter

如下

ALTER proc getWorkPlan2

@intCounter int

,@lngUserID int

as 　

exec ('select Top '+convert(varchar(10),@intCounter)+' lngWorkID,strWorkName,strExecHumanName,strBeginDate from worklist where lngExecHumanID= '

+convert(varchar(10),@lngUserID) +' order by lngWorkID desc '

老是提示　在关键字 'convert' 附近有语法错误。

于是改为

ALTER proc getWorkPlan2

@intCounter int

,@lngUserID int

as

declare @strCounter varchar(10)

set @strCounter=convert(varchar(10),@intCounter)

declare @strUserID varchar(10)

set @strUserID=convert(varchar(10),@lngUserID)

exec ('select Top '+@strCounter+' lngWorkID,strWorkName,strExecHumanName,strBeginDate from worklist where lngExecHumanID= '

+@strUserID +' order by lngWorkID desc '

)

OK！