MSSQL paging implementation by ID _ MySQL

MSSQL paging implementation method based on ID bitsCN.com
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
BitsCN.com