SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[zh_Page]
-- Add the parameters for the stored procedure here
@PageSize int, --每页记录
@PageIndex int, --当前页数,1开始
@Condition varchar(500), --查询条件,包括and,where,必须有一个条件如where 2>1
@TheTable varchar(100), --表名
@SelectField varchar(500), --要选择的字段
@OrderBy varchar (200), --OrderBy字句,包括order
@TableID varchar (50) --table主键
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
declare @Sql varchar(8000)

-- Insert statements for procedure here
--返回记录
set @Sql='select top ' + cast(@PageSize as varchar(10)) + ' ' + @SelectField + ' from ' + @TheTable + ' ' + @Condition + ' and '
+ @TableID +' not in (select top ' + cast((@PageSize*(@PageIndex-1)) as varchar(10))+' '+@TableID+' from ' + @TheTable + ' ' + @Condition
+ ' ' + @OrderBy +') ' + @OrderBy
exec(@sql)

--返回总数
--set @Sql='select count(' + @TableID + ') from ' + @TheTable +' ' + @Condition
--exec(@sql)

END

GO

//sql/1213