[百萬級]通用存儲過程.分頁存儲過程.

CREATE PROCEDURE dbo.spAll_ReturnRows

(

[email protected] nVARCHAR(4000),

[email protected] int,

[email protected] int,

[email protected] VARCHAR(255),

[email protected] VARCHAR(255)

)

AS

DECLARE @Str nVARCHAR(4000)

SET @Str='SELECT?? TOP '+CAST(@RecsPerPage AS VARCHAR(20))+' * FROM ('[email protected]+') T WHERE T.'[email protected]+' NOT IN

(SELECT?? TOP '+CAST((@RecsPerPage*(@Page-1)) AS VARCHAR(20))+' '[email protected]+' FROM ('[email protected]+') T9 ORDER BY '[email protected]+') ORDER BY '[email protected]

PRINT @Str

EXEC sp_ExecuteSql @Str

GO