CREATE PROCEDURE [dbo].[SelectPage_trade]
    @QueryString varchar(8000), --ѯ

    @QueryString2 varchar(8000), --ѯ


    @FieldOrder nvarchar (1000), /*ֶб
    ע⣺Ϊ洢˳Ĳֶͬδظֵܻᵼ·صָҳ¼ЧʱҪһΨһֵֶܡ
    磺һͼдid(ͼ)name(ͼ)ֶΣidֶΨһֵnameֶδظֵ
    Ӱnameļ¼жȡӦʹáORDER BY [name] asc, [id] ascֶб
    С[id] asc[name] asc򣬶ڰnameĽгnameֵͬĶ¼id
    */
    @KeyFieldName nvarchar (250), --СʶлΨһֵ
    @PageIndex int, --ָҳ0ʼ0ʾһҳ
    @PageSize int, --ÿҳĴС(ÿҳʾļ¼)

@countx int output

as
SET @KeyFieldName=N' '+@KeyFieldName

SET @FieldOrder=N' '+ISNULL(@FieldOrder, '')





declare @sql varchar(8000)



declare @sql2 varchar(8000)





declare @TempFieldName nvarchar(50)--ʱֶ
set @TempFieldName=N' [ID_'+cast(newid() as varchar(40))+N']'



declare @sqlstr varchar(8000) 






set @sql=N'declare @tb1 table('+@TempFieldName+N' int IDENTITY(1,1),'+@KeyFieldName+N')


 INSERT INTO @tb1 SELECT   id from '

	
declare @Id1 varchar(20),@Id2 varchar(20) --ʼͽļ¼ 
set  @Id1=cast(@PageSize*(@PageIndex-1) as varchar(20)) 
set  @Id2=cast(@PageSize*@PageIndex-1 as varchar(20)) 



set @sql2=N'
select *  from ruan_qongqiu asss inner join @tb1 axx   on axx.id=asss.id and axx.'+@TempFieldName +N'  between  '+@Id1+N' and  '+@Id2+' order by axx.'+@TempFieldName+ ' asc'


EXEC ( @sql+N'('+@QueryString+@QueryString2+N') a '+@sql2)



--set @countx=@@ROWCOUNT
GO
