(
取自 Worx 英文版的<<Professional Active Server Pages 3.0>>
ISBN1861002610
关头中央我已作了中文翻译
)
CREATE PROCEDURE usp_PagedAuthors
@iPageint,
@iPageSizeint
AS
BEGIN
-- disable row counts
SET NOCOUNT ON
-- declare variables
DECLARE @iStartint-- start record
DECLARE @iEndint-- end record
DECLARE @iPageCountint-- total number of pages