取区间段数据SQL（sqlserver)

exec('select top 5 * from uc_user where user_id > (select max(user_id) from (select top 5 user_id  from uc_user order by user_id) as t)')
select * from uc_user
SELECT TOP 5 * FROM uc_user where user_id>(SELECT MAX(user_id) FROM (SELECT TOP 10 user_id FROM uc_user ORDER BY user_id) as t)

 

/*****************************************************************************************

写的存储过程

******************************************************************************************/

alter proc p_get_page_data --'uc_user','user_id',5,2
(
 @tablename varchar(1000),
 @pk varchar(100),
 @pagesize int,
 @pagenumber int
)
as
declare @tempnumber int
if(@pagesize<1 or @pagenumber<1)
 return;

set @tempnumber = @pagesize*@pagenumber

declare @strSQL varchar(2000)
/*set @strSQL = 'SELECT TOP '+convert(varchar(100),@pagesize)+' * FROM '+@tablename+' where '+ @pk+'>(SELECT MAX('+@pk+') FROM (SELECT TOP '+convert(varchar(100),@tempnumber)+' '+ @pk+' FROM '
 +@tablename+' ORDER BY '+@pk+') as t)'*/

exec 'SELECT TOP '+convert(varchar(100),@pagesize)+' * FROM '+@tablename+' where '+ @pk+'>(SELECT MAX('+@pk+') FROM (SELECT TOP '+convert(varchar(100),@tempnumber)+' '+ @pk+' FROM '
 +@tablename+' ORDER BY '+@pk+') as t)'

--exec ('SELECT TOP 5 * FROM uc_user where user_id>(SELECT MAX(user_id) FROM (SELECT TOP 10 user_id FROM uc_user ORDER BY user_id) as t)')