create table yuan
(
id int identity,
name varchar(40),
age int ,
gong int ,
)
--添加数据
insert into yuan values('张三',15,1500)
insert into yuan values('张三',15,1500)
insert into yuan values('李四',15,1500)
insert into yuan values('张三',15,1500)
insert into yuan values('张三',15,1500)
insert into yuan values('张三',15,1500)
insert into yuan values('李四',15,1500)
insert into yuan values('张三',15,1500)
insert into yuan values('张三',15,1500)
insert into yuan values('张三',15,1500)
insert into yuan values('李四',15,1500)
insert into yuan values('张三',15,1500)
insert into yuan values('李四',15,1500)
go
create proc page
(
@pageindex int, --页数
@pagesize int, --页容量
@name varchar(40)
)
as
begin
select ROW_NUMBER()over(order by id)as pis,
*
into #sko --把数据存入临时表中
from yuan where name like '%'+@name+'%'
select
(select count(*)from #sko)as pagecount, --总页数
* from #sko
where pis between ((@pageindex-1)*@pagesize+1) and (@pageindex*@pagesize)
end
数据库分页
最新推荐文章于 2020-01-07 10:25:57 发布