免费视频淫片aa毛片_日韩高清在线亚洲专区vr_日韩大片免费观看视频播放_亚洲欧美国产精品完整版

/*
名稱:spAll_ReturnRows
輸入:
輸出:
調(diào)用:
EXEC spAll_ReturnRows ‘SELECT? * FROM 表名‘, 頁號(hào), 返回記錄數(shù), ‘主鍵‘, ‘排序字段‘
spAll_ReturnRows ‘SELECT? * FROM all_Categories‘,2,10,‘[ID]‘,‘[ID]‘
說明:[百萬級(jí)]通用存儲(chǔ)過程.分頁存儲(chǔ)過程..返回指定返回條數(shù)、指定頁數(shù)的記錄
作者:Dili J.F. Senders
郵件:diliatwellknow.net
網(wǎng)站:http://12986.com
更新:20040610
支持:http://cs.12986.com
版權(quán):轉(zhuǎn)述時(shí)請(qǐng)注明來源
*/

CREATE PROCEDURE dbo.spAll_ReturnRows
(
@SQL nVARCHAR(4000),
@Page int,
@RecsPerPage int,
@ID VARCHAR(255),
@Sort VARCHAR(255)
)
AS

DECLARE @Str nVARCHAR(4000)

SET @Str=‘SELECT?? TOP ‘+CAST(@RecsPerPage AS VARCHAR(20))+‘ * FROM (‘+@SQL+‘) T WHERE T.‘+@ID+‘ NOT IN
(SELECT?? TOP ‘+CAST((@RecsPerPage*(@Page-1)) AS VARCHAR(20))+‘ ‘+@ID+‘ FROM (‘+@SQL+‘) T9 ORDER BY ‘+@Sort+‘) ORDER BY ‘+@Sort

PRINT @Str

EXEC sp_ExecuteSql @Str
GO