分页存储过程

create procedure PageProc
(
@TableName varchar(20),
@pageIndex int,
@pageSize int
)
as
begin
set nocount on;
declare @sql nvarchar(500)
--declare @RecordCount int
--declare @PageCount int

--select @RecordCount=count(*) from @TableName
--Set @PageCount=(@RecordCount-1)/@PageSize+1

set @sql='select top '+str(@pageSize)+' * From '+@TableName+' where(ID<(select max(id) From (select top '+str(@pageSize*@pageIndex)+' id From '+@TableName+' order by ID desc) as TempTable)) order by ID desc'
execute(@sql)
set nocount off;
end