分页

      SELECT @TotalCount=COUNT(1) 
        FROM TuningRules a WITH(NOLOCK) 
        WHERE a.[Status] <> 'V' 

        SELECT 
        tmp.RuleId 
           FROM (

        SELECT 
        ROW_NUMBER() OVER (ORDER BY a.RuleId DESC) AS RowNo 
        ,a.RuleId 
     
        ,(A.LastEditUser + ' ' + CONVERT(VARCHAR(100),A.LastEditDate, 20)) AS EditBy 
        FROM TuningRules a WITH(NOLOCK) 
        WHERE a.[Status] <> 'V' 
        ) AS tmp 
        WHERE tmp.RowNo > @PageFlag AND tmp.RowNo <= @PageFlag + @PageSize