SQL2005 存储过程分页

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

-- =============================================
-- Description:    通用存储过程分页
-- @PageIndex:    当前页码
-- @PageSize：    每页显示的记录条数
-- =============================================
ALTER PROCEDURE [dbo].[GeneralSPOfPaging]
    -- Add the parameters for the stored procedure here
    @PageIndex int ,
    @PageSize int 
AS

BEGIN

    SET NOCOUNT ON;
 
    SELECT        
            *
    FROM 
            (
                SELECT 
                            ROW_NUMBER() OVER (ORDER BY HeTID DESC)AS Row
                        ,    * 
                FROM 
                        dbo.ECS_HeT
            ) as list
                WHERE 
                        Row 
                            between 
                                    (@PageIndex - 1) * @PageSize + 1 
                            and 
                                    @PageIndex*@PageSize 
END