alter proc fy @pagesize int,--一页多少个 @pageidex int,--页码 @tablename varchar(50),--表名字 @key varchar(50)--主键 as declare @sqlstr varchar(8000) declare @ps varchar(50) declare @pi varchar(50) declare @k varchar(50) set @ps=cast(@pagesize as varchar) set @pi=cast(@pageidex as varchar) set @k=cast(@key as varchar) set @sqlstr='select top '+@ps+' * from '+@tablename+' where '+@k+' not in (select top '+cast(@pagesize*@pageidex as varchar)+@k+' from '+@tablename+')'exec (@sqlstr) 如过要执行 exec fy 5,1,'fuction','id' 我这里用的是我的表
@pagesize int,--一页多少个
@pageidex int,--页码
@tablename varchar(50),--表名字
@key varchar(50)--主键
as
declare @sqlstr varchar(8000)
declare @ps varchar(50)
declare @pi varchar(50)
declare @k varchar(50)
set @ps=cast(@pagesize as varchar)
set @pi=cast(@pageidex as varchar)
set @k=cast(@key as varchar)
set @sqlstr='select top '+@ps+' * from '+@tablename+' where '+@k+' not in (select top '+cast(@pagesize*@pageidex as varchar)+@k+' from '+@tablename+')'exec (@sqlstr) 如过要执行 exec fy 5,1,'fuction','id' 我这里用的是我的表
http://www.webdiyer.com/AspNetPager/utility/sqlspgen.aspx
声明一个临时表,附带一个自增长的字段,查询的结果输入这里,
然后取对应区间当然,这不是什么好方法,在网上自己搜一下吧,有快速的---------------------------------------------------
http://bbs.msproject.cn/.NET开源代码及技术文章
---------------------------------------------------