declare @topn int set @topn=@pagesize*@startindexexec('select top (' +@pagesize+ ') * from Error where ER_ID Not In(select top('+@topn+' ) ER_ID from Error order by ER_ID DESC) order by ER_ID DESC')
DECLARE @sql VARCHAR(8000) SET @sql='select top ' +RTRIM(@pagesize)+ ' * from Error where ER_ID Not In(select top ' +RTRIM(@pagesize*@startindex)+ ' ER_ID from Error order by ER_ID DESC) order by ER_ID DESC' EXEC(@sql)
set @topn=@pagesize*@startindexexec('select top (' +@pagesize+ ') * from Error where ER_ID Not In(select top('+@topn+' ) ER_ID from Error order by ER_ID DESC) order by ER_ID DESC')
SET @sql='select top ' +RTRIM(@pagesize)+ ' * from Error where ER_ID Not In(select top ' +RTRIM(@pagesize*@startindex)+ ' ER_ID from Error order by ER_ID DESC) order by ER_ID DESC'
EXEC(@sql)
是我搞错了,他的是对的,就是怎么查询不出来数据,我把变量换成实在的数字是能查出来的,调试的时候startindex和pagesize都是有值的