(
  @pageindex int,--行數--
  @pagenum int,--頁次--
  @strsql nvarchar(4000),--SQL語句--
  @order nvarchar(50),--排序字段--
  @count int output --輸出參數，總行數--
)
as
 declare @orderdesc nvarchar(100)
 declare @orderasc nvarchar(100)
 declare @sql nvarchar(4000)
 declare @rows int
begin
 set @sql='select @a=count(*) from (' +@strsql+ ') as a '
 exec sp_executesql @sql,N'@a int output',@count output
 set @rows=@pageindex*@pagenum
 if(@rows>@count)
     set @pageindex=@pageindex-(@rows-@count)
 if(@pageindex<0)
 set @pageindex=0
 if @order!=''
 begin
  set @orderdesc='order by '+@order+' desc'
  set @orderasc='order by '+@order+' asc'
 end
 else
 begin
  set @orderdesc='order by id desc'
  set @orderasc='order by id asc'
    end
exec('
select * from (
select top '+@pageindex+' * from(
select * from (
select top ('+@rows+') * from ('+@strSql+' ) as a '+@orderdesc+')
as a  ) as a '+@orderasc+') as a '+@orderdesc+'
')
end

CRM定制，辦公OA，軟件開發，沈陽易勢科技最專業