/**/
/*
![](https://i-blog.csdnimg.cn/blog_migrate/499c37fb298d154d2810e30406a4a64a.gif)
名称:spAll_ReturnRows
![](https://i-blog.csdnimg.cn/blog_migrate/691edba9ec1bb1a550c2dd123974d37d.gif)
输入:
![](https://i-blog.csdnimg.cn/blog_migrate/126e4a70bc1cdcede368515d6d2153f4.gif)
输出:
![](https://i-blog.csdnimg.cn/blog_migrate/ca154643985e8f706dceaee8dc43daa8.gif)
调用:
![](https://i-blog.csdnimg.cn/blog_migrate/a2ad5974b5975115d9bdc72a18db7b0c.gif)
EXEC spAll_ReturnRows 'SELECT * FROM 表名', 页号, 返回记录数, '主键', '排序字段'
![](https://i-blog.csdnimg.cn/blog_migrate/c5c2eff6959086a0e8a8e70ced0f5478.gif)
spAll_ReturnRows 'SELECT * FROM all_Categories',2,10,'[ID]','[ID]'
![](https://i-blog.csdnimg.cn/blog_migrate/20952985836822fee28081c6a8e96923.gif)
说明:[百万级]通用存储过程.分页存储过程..返回指定返回条数、指定页数的记录
![](https://i-blog.csdnimg.cn/blog_migrate/babed8bdd7f0361b173669521c06168c.gif)
作者:Dili J.F. Senders
![](https://i-blog.csdnimg.cn/blog_migrate/6fc2ace554cb30411b58990335a25fd8.gif)
邮件:diliatwellknow.net
![](https://i-blog.csdnimg.cn/blog_migrate/0486a9e2a88950d97b0a59c16076dd19.gif)
网站:http://www.wellknow.net
![](https://i-blog.csdnimg.cn/blog_migrate/4719cda70125ca3162e3d853d85b87fd.gif)
更新:20040610
![](https://i-blog.csdnimg.cn/blog_migrate/2f33beec183a3c268b7ff519a52e12bb.gif)
支持:http://bbs.wellknow.net
![](https://i-blog.csdnimg.cn/blog_migrate/6630f18e480ebfbac76360da04a38bbc.gif)
版权:转述时请注明来源:用思维创造未来的Wellknow.net
*/
CREATE
PROCEDURE
dbo.spAll_ReturnRows
![](https://i-blog.csdnimg.cn/blog_migrate/cae998c99ff15048f55565052eb3afb7.png)
(
![](https://i-blog.csdnimg.cn/blog_migrate/8bcc108a92ed87f8de884038a5aa5ae6.png)
@SQL
nVARCHAR
(
4000
),
![](https://i-blog.csdnimg.cn/blog_migrate/30ffb622c56963580d9b12aa414ff054.png)
@Page
int
,
![](https://i-blog.csdnimg.cn/blog_migrate/4a15625f70897fda0f484e2527e65805.png)
@RecsPerPage
int
,
![](https://i-blog.csdnimg.cn/blog_migrate/491e16ebad260122ed9528c782dda827.png)
@ID
VARCHAR
(
255
),
![](https://i-blog.csdnimg.cn/blog_migrate/2c43f8d18fe746270233b4eed6a35373.png)
@Sort
VARCHAR
(
255
)
![](https://i-blog.csdnimg.cn/blog_migrate/7d1603c06926f7de0255f3d01bf5f61f.png)
)
AS
DECLARE
@Str
nVARCHAR
(
4000
)
SET
@Str
=
'
SELECT TOP
'
+
CAST
(@RecsPerPage
AS
VARCHAR
(
20
))
+
'
* FROM (
'
+
@SQL
+
'
) T WHERE T.
'
+
@ID
+
'
NOT IN
![](https://i-blog.csdnimg.cn/blog_migrate/c56aceee2477913783dc74d256e11674.png)
(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