create proc proc_pager
@tblName varchar(20),--表名
@pageSize int=10,--每页数据行数
@pageNum int=1,--页数
@sortName varchar(20)--排序列名
AS
DECLARE @count int
set @count = @pageSize * (@pageNum-1)--去掉的数据
exec
('select top '+@pageSize+' * from
(
select * from '+@tblName+' where '+@sortName+' not in
(select top '+@count+' '+@sortName+' from '+@tblName+' order by '+@sortName+')
) as au
order by '+@sortName
)
GO