如何返回包含所有行和所有行数的对象

Question

我有一个根据页码返回 20 行的存储过程：

CREATE PROCEDURE SP_GET_ALL
    @PAGE INT
AS
    SELECT * 
    FROM Item
    ORDER BY ID
        OFFSET (@PAGE - 1) * 20 ROWS
        FETCH NEXT 20 ROWS ONLY

当我使用 API 时，结果如下所示，

[
    {id:1, name:"name1"},
    {id:2, name:"name2"},
    {id:3, name:"name3"},
    {id:4, name:"name4"},
    {id:5, name:"name5"},
    {id:6, name:"name6"},
    {id:7, name:"name7"},
    ....
]

我想返回同一查询中所有行的总数以设置网页分页。例如，

{
    count: 1000,
    rows:[
            {id:1, name:"name1"},
            {id:2, name:"name2"},
            {id:3, name:"name3"},
            {id:4, name:"name4"},
            {id:5, name:"name5"},
            {id:6, name:"name6"},
            {id:7, name:"name7"},
            ....
        ]   
}

我不想执行两个请求来获取行和所有行的总数。