老调试不成功的存储过程,一个堵我心口好久的问题。
该存储过程老说:“@indextable没有声明”,我明明声明了,晕倒。
CREATE procedure s_Tables_Page
(
@pagesize int,
@pageindex int,
@table varchar(200)
)
as
set nocount on
declare @indextable table(id int identity(1,1),nid int)
declare @PageLowerBound int
declare @PageUpperBound int
set @PageLowerBound=(@pageindex-1)*@pagesize
set @PageUpperBound=@PageLowerBound+@pagesize
set rowcount @PageUpperBound
exec ('insert into '+@indextable+'(nid) select id from '+@table+' order by id desc')
exec ('select * from '+@table+' O,'+@indextable+'t where O.id=t.nid and t.id>'+@PageLowerBound+' and t.id<='+@PageUpperBound+' order by t.id')
set nocount off
GO