fffffffffff

最新推荐文章于 2022-05-02 14:47:42 发布

转载最新推荐文章于 2022-05-02 14:47:42 发布 · 81 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/laopo/p/4762238.html

create proc partPage114
@n int,--每页数量
@page int, --页码从0开始
@Mainkey int
as
declare @sql nvarchar(1000)
begin
set @sql='select top '+cast(@n as varchar(50))+' * from Print_order where ('+cast((@Mainkey *@page) as varchar(50))+') not in(select top ('+cast((@n *@page) as varchar(50))+')  ('+cast((@Mainkey *@page) as varchar(50))+') from Print_order order by ('+cast((@Mainkey *@page) as varchar(50))+')) order by ('+cast((@Mainkey *@page) as varchar(50))+')'
exec(@sql)
end
exec partPage111 10,1

转载于:https://www.cnblogs.com/laopo/p/4762238.html