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
selectROW_NUMBER()over(order by id)as pis,*into #sko --把数据存入临时表中
from yuan where name like '%'+@name+'%'select(selectcount(*)from #sko)as pagecount,--总页数
*from #sko
where pis between ((@pageindex-1)*@pagesize+1) and (@pageindex*@pagesize)
end
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...