create proc DoctorDetailed

@CreaterTime time,--开始时间

@EndTime time,--结束时间

@page int,--页码

@rows int,--页数

@DoctorName Nvarchar(),--医生名字

AS

begin

declare @sql1 nvarchar()

declare @sql2 nvarchar()

declare @page1 int

declare @rows1 int

 --此处为分页计算

 set @page1=(@page-)*@rows+

 set @rows1= @page*@rows

set @sql1 =' SELECT * FROM (select ROW_NUMBER() OVER(ORDER BY '排序字段' desc  ) AS rownum,*

　　　　　　　 from( select * from as '需要查询的内容' ) as A where ='

set @sql2='          

     ) AS Dwhere where = '

--多条件查询，判断是否字符串传进来为空，不为空则加上条件查询

   IF @DoctorName!=''

        BEGIN

            SET @sql1=@sql1+ ' AND Dwhere.条件查询的列名字（例子：Dwhere.DoctorName）='''+@DoctorName+''' '

        END

  --分页条件查询   此处传进来的 页数 需要 转换

   SET @sql2=@sql2+ 'AND  rownum  between '+cast(@page1 as varchar())+' and '+cast(@rows1 as varchar())+''

 end