-- ================================================
-- Template generated from Template Explorer using:
-- Create Procedure (New Menu).SQL
--
-- Use the Specify Values for Template Parameters
-- command (Ctrl-Shift-M) to fill in the parameter
-- values below.
--
-- This block of comments will not be included in
-- the definition of the procedure.
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: munaiwu
-- Create date: 20091030
-- Description: 公文分页存储过程
-- =============================================
CREATE PROCEDURE pagination1
-- Add the parameters for the stored procedure here
@pagesize int, --页面大小,如每页存储20条记录
@pageindex int ---当前页号
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON; --不返回计数,不返回任何结果集
-- Insert statements for procedure here
declare @indextable table(id int identity(1,1),nid int) --表变量
declare @PageLowerBound int --定义页面底码
declare @PageUpperBound int --定义页面顶码
set @PageLowerBound = (@pageindex - 1)* @pagesize
set @PageUpperBound = @PageLowerBound + @pagesize
set rowcount @PageUpperBound --在达到指定的行数后停止处理
insert into @indextable(nid) select gid from TGongwen where fariqi > dateadd(day,-365,getdate()) order by fariqi desc
select O.gid,O.mid,O.title,O.fadanwei,O.fariqi from TGongwen as O, @indextable as t where O.gid=t.nid and t.id>@PageLowerBound and t.id<=@PageUpperBound order by t.id
END
set nocount off --返回计数,返回任何结果集
GO