Sql语句分页技术

    适用于 SQL Server 2000/2005 

SELECT TOP 页大小 *    
FROM table1    
WHERE id NOT IN    
          (    
          SELECT TOP 页大小*(页数-1) id FROM table1 ORDER BY id    
          )    
ORDER BY id 

适用于 SQL Server 2000/2005 
SELECT TOP 页大小 *    
FROM table1    
WHERE id >    
          (    
          SELECT ISNULL(MAX(id),0)     
          FROM     
                (    
                SELECT TOP 页大小*(页数-1) id FROM table1 ORDER BY id    
                ) A    
          )    
ORDER BY id   

适用于 SQL Server 2005 

SELECT TOP 页大小 *     
FROM     
        (    
        SELECT ROW_NUMBER() OVER (ORDER BY id) AS RowNumber,* FROM table1    
        ) A    
WHERE RowNumber > 页大小*(页数-1)