存储过程中的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！
|
