declare @Page int
declare @PageSize int
declare @RowNumber int
select @Page=1
select @PageSize=10
select @[email protected][email protected]
select top @PageSize *
from 基本信息_物品基本信息
where id not in(select top @RowNumber id from 基本信息_物品基本信息 order by id)
order by id
------解决方案--------------------
试试:
exec( 'select top '[email protected]+ ' *
from 基本信息_物品基本信息
where id not in(select top '[email protected]+ ' id from 基本信息_物品基本信息 order by id)
order by id ')
------解决方案--------------------
exec( 'select top '+cast(@PageSize as varchar(20))+ ' *
from 基本信息_物品基本信息
where id not in(select top '+cast(@RowNumber as varchar(20))+ ' id from 基本信息_物品基本信息 order by id)
order by id ')
------解决方案--------------------
--try
declare @Page int
declare @PageSize int
declare @RowNumber int
select @Page=1
select @PageSize=10
select @[email protected][email protected]
exec( '
select top '[email protected]+ ' *
from 基本信息_物品基本信息
where id not in(select top @RowNumber id from 基本信息_物品基本信息 order by id)
order by id
')