ALTER PROCEDURE GetData
@pagesize INT,--10
@pagenum INT--2
AS
SELECT * FROM (
SELECT ROW_NUMBER() OVER (ORDER BY dbo.user_info.id)AS rowid,* FROM dbo.user_info
)AS t
WHERE t.rowid BETWEEN @pagenum*@pagesize+1 AND (@pagenum+1)*@pagesize
exec getdata 10,3
SQL 创建存储过程 语法
最新推荐文章于 2023-10-12 12:21:37 发布