set nocount on
/*声明查询字符串*/
declare @strSQL nvarchar(4000)
set @strSQL = '' select @TotalCount=count(*) from () as t ''
/*取得查询结果总数*/
exec sp_executesql
@strSQL,
int=0 OUTPUT'',
@TotalCount=@TotalCount OUTPUT
declare @ItemCount int
declare @_PageIndex int
set @_PageIndex = @PageIndex + 1;
/*确定搜索边界*/
set @ItemCount = @TotalCount - @PageSize * @_PageIndex
if(@ItemCount < 0)
set @ItemCount = @ItemCount + @PageSize
else
set @ItemCount = @PageSize
if(@ItemCount < 0) return 1
if(@Sort != '''')
begin
/*声明排序变量*/
declare @IndexSort1 nvarchar(50), @IndexSort2 nvarchar(50), @Sort1 nvarchar(50), @Sort2 nvarchar(50)
SET @Sort1 = @Sort
SET @Sort2 = Replace(Replace(Replace(@Sort, ''DESC'', ), ''ASC'', ''DESC''), , ''ASC'')
print @Sort1
print @Sort2
set @strSQL = ''SELECT * FROM
(SELECT TOP '' + STR(@ItemCount) + '' * FROM
(SELECT TOP '' + STR(@PageSize * @_PageIndex) + '' * FROM
() AS t0
ORDER BY +'') AS t1
ORDER BY +'') AS t2
ORDER BY ''
end
else
begin
set @strSQL = ''SELECT * FROM
(SELECT TOP '' + STR(@ItemCount)
Copyright © 2019- 7swz.com 版权所有 赣ICP备2024042798号-8
违法及侵权请联系:TEL:199 18 7713 E-MAIL:2724546146@qq.com
本站由北京市万商天勤律师事务所王兴未律师提供法律服务