SQL分页存储过程

自己写的一个SQL分页存储过程,原理来自网上的一篇文章,
原理为:

select top 页大小 *
from table1
where id >
( select max (id) from
( select top ((页码 - 1 ) * 页大小) id from table1 order by id) as T
)

CREATE procedure GetLYZXNews
@type int , -- 文章类型
@Pgs int , -- 页大小
@Pgn int -- 页码，页码为0则为求总页数
as
declare @strsql varchar ( 500 ) -- 执行的SQL语句
declare @ZongShu int -- 记录总数
declare @YeShu int -- 总页数
declare @strTmp int -- 临时变量
if @Pgn = 0
     begin
     select @ZongShu = count ( * ) from LYNews where type = @type
     if @ZongShu <= @Pgs
       begin
         if @ZongShu = 0
           begin
                 set @YeShu = 0
               end
             else
               begin
                 Set @YeShu = 1
               end
       end
     else
           begin
             set @strTmp = @ZongShu % @Pgs
             if @strTmp = 0
             begin
               set @YeShu = @ZongShu / @Pgs
             end
             else
             begin
               set @YeShu = @ZongShu / @Pgs + 1
             end
           end
         set @strsql = " select " + str ( @ZongShu ) + " as ZongShu," + str ( @YeShu ) + " as YeShu"
     end
else
     begin
     if @Pgn = 1
begin
set    @strsql = " select top " + str ( @Pgs ) + " * from LyNews Where type = " + str ( @type ) + " order by postDate desc "
end
else
begin
set @strsql = " select top " + str ( @Pgs ) + " * from LyNews Where type = " + str ( @type ) + " and postDate < ( select min (postDate) from "
set @strsql = @strsql + "( select top " + str (( @Pgn - 1 ) * @Pgs ) + " * from LyNews where type = " + str ( @type ) + " order by postdate desc ) as t) order by postDate desc "
end
     end
exec ( @strSQL )
GO