CREATE Procedure dbo.Pr_GetListByPage
@PageIndex int, --当前页码
@PageSize int --每页记录数
As
Declare @SqlStr nvarchar(4000)
If(@PageIndex=1)
Begin
Set @SqlStr = 'Select Top '+Convert(nvarchar(15),@PageSize)+' * From 表名 Order By id DESC'
End
Else
Begin
Set @SqlStr = 'Select Top '+Convert(nvarchar(15),@PageSize)+' * from 表名 where id Not In(Select Top '+Convert(nvarchar(15),(@PageIndex-1)*@PageSize)+' id From 表名 Order By id Desc) Order By id DESC'
End
Execute Sp_ExecuteSql @SqlStr
Set @SqlStr = 'Select Count(*) From 表名 '
Execute Sp_ExecuteSql @SqlStr
GO