简单存储过程分页

GO
/****** Object:  StoredProcedure [dbo].[page_news]    Script Date: 08/21/2012 16:55:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[page_news]
@PageNumber int = 1,    --开始页码
@PageSize int = 10,        --页大小
@isCount bit = 0     --1    --是否获得总记录数
as
if @isCount=0
 select Top(@PageSize) * from  ad_news  where
 NewsID<>(select top 1 NewsID from ad_News where isTop=1 order by CreateDate Desc)
 and NewsID not in (select top (@PageSize*(@PageNumber-1))  NewsID from ad_news where
 NewsID<>(select top 1 NewsID from ad_News where isTop=1 order by CreateDate Desc)
 order by CreateDate desc)
 order by CreateDate desc
else
 select COUNT(*) from ad_news