一个简单Paging自定义分页范例

create proc paging @pageIndex int, @pageSize int, @tableName varchar(50), @orderColumn varchar(30) as declare @sqlstring varchar(1000) set @sqlstring='select top '+cast(@pageSize as varchar(10))+'* from ( select top '+cast(@pageSize as varchar(10))+' * from ( select top '+cast(@pageIndex*@pageSize as varchar(10)) +' * from '+@tableName+' order by '+@orderColumn+') as newtable order by '+@orderColumn+' desc ) as ascTable order by '+@orderColumn exec(@sqlstring)