if exists (select * from sys.databases where name='test')drop database testcreate database testgouse testgo/----创建员工信息表(employeeInfo)if exists(......
order by empId
go
execute EmployeeInfoPage 10000,10
go
/--创建 排序储存过程
if exists(select * from sys.procedures where name='EmployeeInfoPageByDesc')
drop procedure EmployeeInfoPageByDesc
/--创建存储过程（EmployeeInfoPageByDesc）
create procedure EmployeeInfoPageByDesc
@startRowIndex int=1 ,
@pageSize int=10
as
declare @recordCount int
execute @recordCount=selectEmployeeInfoCount
select top(@pageSize) * from employeeInfo
(select top (@recordCount-(@startRowIndex-1)*@pageSize) * from employeeInfo order by empId desc)
emp
order by empId asc
go
select top (100-(2-1)*10) * from employeeInfo order by empId desc
2/2 首页 上一页 1 2 |
