MSSQL根据ID进行分页实现方法

这篇文章主要为大家详细介绍了MSSQL根据ID进行分页实现方法，具有一定的参考价值，可以用来参考一下。

对此感兴趣的朋友，看看idc笔记做的技术笔记！

代码如下:

 
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 

注：关于MSSQL根据ID进行分页实现方法的内容就先介绍到这里，更多相关文章的可以留意