学步园

 create proc Pageproc<br /> (<br /> @TableName varchar(50), --表名<br /> @pagecount int, --当前页索引<br /> @pagesize int, --每页显示的行数<br /> @zongye int output --总行数<br /> )<br /> as</p> <p>--获取总行数<br /> declare @zonghang int;<br /> declare @getcountsql nvarchar(500)<br /> set @getcountsql='select @a=count(*) from '+@TableName+' '<br /> exec sp_executesql @getcountsql,N'@a int output',@zonghang output --把执行的结果赋给变量@zonghang</p> <p>declare @strSql nvarchar(500)<br /> set @strSql='select top '+convert(varchar,@pagesize)+' * from '+@TableName+'';<br /> begin<br /> if @pagecount!=0<br /> begin<br /> set @strSql=@strSql+'where id>(select max(id) from (select top ('+@pagesize*@pagecount+') id from '+@TableName+' order by id asc) as aa)'<br /> end<br /> exec sp_executesql @strSql;<br /> end<br /> begin<br /> if @zonghang%@pagesize!=0<br /> begin<br /> set @zongye=(@zonghang/@pagesize)+1;<br /> end<br /> else<br /> begin<br /> set @zongye=@zonghang/@pagesize;<br /> end<br /> end