Node Express

Node Express"/>

Node Express

我正在使用node+express和mssql npm包，我想知道sql.request在记录集和记录集中返回相同的信息，我开始知道记录集属性应该只返回第一条记录。但它失败了...

数据库：

代码：

var sqlRequest = new sql.Request();

sqlRequest.query("select * from Users", function (err: any, result: any) {
  if (err) console.log(err);

  return OkReply("Records fetched", result);
});

结果：

{
"code": 200,
"message": "Records fetched",
"data": {
    "recordsets": [
        [
            {
                "ID": 0,
                "UserName": "admin",
                "Password": "admin"
            },
            {
                "ID": 1,
                "UserName": "admin2",
                "Password": "admin2"
            }
        ]
    ],
    "recordset": [
        {
            "ID": 0,
            "UserName": "admin",
            "Password": "admin"
        },
        {
            "ID": 1,
            "UserName": "admin2",
            "Password": "admin2"
        }
    ],
    "output": {},
    "rowsAffected": [
        2
    ]
  }
}