未完成

create   PROCEDURE  Proc_Pagination 
    @Tablename   nvarchar ( 40 ) , 
    @KeyField   nvarchar ( 20 ),
    @CurrentPage   int ,
    @PageSize   int ,
    @IntOrder   bit = 0
AS  
begin
     declare   @SQL   nvarchar ( 1000 )
     if ( @CurrentPage = 1 )
     begin
         set   @SQL = ' select top ' + @PageSize +   ' from ' +   @TableName + ' order by ' + @KeyField
         if ( @IntOrder = 1 )
         begin
         set   @SQL = @SQL + ' asc '
         end
         else
         begin
         set   @SQL = @SQL + ' desc '
         end
     end
     else  
     begin

         if ( @IntOrder = 1 )
         begin
         set   @SQL = ' select top ' + @PageSize +   ' from ' +   @TableName + ' where ' + @KeyField
             + ' not in(select top  ' + ( @CurrentPage - 1 ) * @PageSize + '   ' + @KeyField
             + ' from ' + @TableName + ' order by ' + @KeyField + ' asc) order by ' + @KeyField
             + ' asc '
         end  
         else
         set   @SQL = ' select top ' + @PageSize +   ' from ' +   @TableName + ' where ' + @KeyField
             + ' not in(select top  ' + ( @CurrentPage - 1 ) * @PageSize + '   ' + @KeyField
             + ' from ' + @TableName + ' order by ' + @KeyField + ' desc) order by ' + @KeyField
             + ' desc '
     end
exec   @SQL
end