alter procedure [a0919194122].[dnt_getappinvitelist]
@uid int,
@pageindex int,
@pagesize int
as
declare @startrow int,
@endrow int
set @startrow = (@pageindex - 1) * @pagesize
if @pageindex = 1
begin
exec(
'select top '[email protected]+' [id],[typename],[appid],[type],[fromuid],[touid],[myml],[datetime],[hash] from [dnt_myinvite] where [touid]='[email protected]+' order by [id] desc'
)
end
else
begin
exec('
select
top '[email protected]+'
[id],[typename],[appid],[type],[fromuid],[touid],[myml],[datetime],[hash]
from [dnt_myinvite]
where [touid]='[email protected]+'
and [id] < (select min([id]) from (select top '[email protected]+' [id]
from [dnt_myinvite]
where [touid]='[email protected]+'
order by [id] desc
) as t
)
order by [id] desc
')
end
如您对本文有疑问或者有任何想说的,请点击进行留言回复,万千网友为您解惑!