数据库分页

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