create proc dis_page
@begin int,
@end int
as
begin
declare @v int
set @v=@end-@begin
exec('select top '+cast(@v as varchar(20))+' * from 表 where 排序列 not in(select top '+cast(@begin as varchar(20))+' 排序列 from order by 排序列) order by 排序列)
end
分页存储过程
最新推荐文章于 2020-02-25 09:58:54 发布