create procedure Error_Get
(
@startindex int,
@pagesize int
)
as
begin
select top (@pagesize) * from Error where ER_ID Not In(select top(@pagesize*@startindex) ER_ID from Error order by ER_ID DESC) order by ER_ID DESC
end
go上面的语句在SQL2005中执行正常,为毛在sql2000中就是错误的,请高手指点下
(
@startindex int,
@pagesize int
)
as
begin
select top (@pagesize) * from Error where ER_ID Not In(select top(@pagesize*@startindex) ER_ID from Error order by ER_ID DESC) order by ER_ID DESC
end
go上面的语句在SQL2005中执行正常,为毛在sql2000中就是错误的,请高手指点下
(
@startindex int,
@pagesize int
)
as
begin
EXEC('select top '+@pagesize+' * from Error where ER_ID Not In(select top(@pagesize*@startindex) ER_ID from Error order by ER_ID DESC) order by ER_ID DESC')
end
go
exec('select top (' +ltrim(@pagesize)+ ') * from Error where ER_ID Not In(select top(' +ltrim(@pagesize*@startindex)+ ') ER_ID from Error order by ER_ID DESC) order by ER_ID DESC')