示例:CREATE PROCEDURE dbo.GetProducts( @PageNum int, @RowsPerPage int, @TotalCount int out) AS CREATE TABLE #Temp (RowNum int IDENTITY(1,1) PRIMARY KEY, ProductID int) INSERT INTO #Temp (ProductID) SELECT ProductID FROM Products ORDER BY CatagoryID
SELECT @TotalCount=@@ROWCOUNT
SELECT RowNum, Products.ProductID, Name, ... FROM #Temp LEFT OUTER JOIN Products ON (#Temp.ProductID= Products.ProductID) WHERE RowNum BETWEEN ((@PageNum-1)*@RowsPerPage+1) AND @PageNum*@RowsPerPage ORDER BY CatagoryID RETURN
@PageNum int,
@RowsPerPage int,
@TotalCount int out)
AS
CREATE TABLE #Temp (RowNum int IDENTITY(1,1) PRIMARY KEY,
ProductID int)
INSERT INTO #Temp (ProductID)
SELECT ProductID FROM Products
ORDER BY CatagoryID
SELECT @TotalCount=@@ROWCOUNT
SELECT RowNum, Products.ProductID, Name, ...
FROM #Temp LEFT OUTER JOIN Products
ON (#Temp.ProductID= Products.ProductID)
WHERE RowNum BETWEEN ((@PageNum-1)*@RowsPerPage+1) AND @PageNum*@RowsPerPage
ORDER BY CatagoryID RETURN
他那个网站上有个代码工具,帮你生成sql存储过程,你可以试试