SQL Server分頁模板

1、效率最高的，受限於主鍵為一個，且主鍵是數字或者可以轉化數字兩段代碼一致，第一段用於閱讀，第二段用於Ctrl+C到程式中。用string替換%%之間欄位即可。

SELECT TOP %頁大小% *FROM %表名%WHERE %主鍵% >          (          SELECT ISNULL(MAX(%主鍵%),0)           FROM                 (                SELECT TOP %頁大小%*(%頁數%-1) %主鍵% FROM %表名%                WHERE 1=1 and (%客戶的條件%)                ORDER BY %主鍵%                ) A          )and  (%客戶的條件%)ORDER BY %主鍵%

SELECT TOP %頁大小% * FROM %表名% WHERE [%主鍵%] > (SELECT ISNULL(MAX([%主鍵%]),0)  FROM  (SELECT TOP %頁大小%*(%頁數%-1) [%主鍵%] FROM %表名% WHERE 1=1 and (%客戶的條件%)  ORDER BY [%主鍵%]) A ) and  (%客戶的條件%) ORDER BY [%主鍵%]

2、次高效率，沒有限制，同樣兩段

SELECT TOP %頁大小% * FROM %表名% WHERE %主鍵% NOT IN (SELECT TOP %頁大小%*(%頁數%-1) %主鍵% FROM %表名% WHERE 1=1 and (%客戶的條件%) ORDER BY %主鍵%) and (%客戶的條件%) ORDER BY %主鍵%

SELECT TOP %頁大小% *FROM %表名% WHERE %主鍵% NOT IN         (SELECT TOP %頁大小%*(%頁數%-1) %主鍵%         FROM %表名%         WHERE 1=1 and (%客戶的條件%)         ORDER BY %主鍵%) and (%客戶的條件%) ORDER BY %主鍵%