首页 / 数据库 / MySQL / MSSQL根据ID进行分页实现方法

复制代码 代码如下:
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 "+@pagesize+" [id],[typename],[appid],[type],[fromuid],[touid],[myml],[datetime],[hash] FROM [dnt_myinvite] WHERE [touid]="+@uid+" ORDER BY [id] DESC"
）
END
ELSE
BEGIN
EXEC（"
SELECT
TOP "+@pagesize+"
[id],[typename],[appid],[type],[fromuid],[touid],[myml],[datetime],[hash]
FROM [dnt_myinvite]
WHERE [touid]="+@uid+"
AND [id] < （SELECT MIN（[id]） FROM （SELECT TOP "+@startRow+" [id]
FROM [dnt_myinvite]
WHERE [touid]="+@uid+"
ORDER BY [id] DESC
） AS T
）
ORDER BY [id] DESC
"）
END