我正在尝试在SQL Server 2016中查询下面这个具有特定结构的JSON,我想找到所有'key'具有特定值的记录。请问如何实现?
{
"nodeDataArray": [{
"key": "5B502176-E51A-48B7-B8F0-350984CFBCF2",
"category": "IFM"
}, {
"key": "1260263E-6111-47B2-9776-FE9BA5C90DCB",
"category": "IFM"
}, {
"key": "8AE454D3-944E-47BE-8CA9-049318DE213B",
"category": "IFM"
}, {
"key": "96B20972-F88C-44BA-84AA-C1F45BE5C7D5",
"category": "IFM"
}
}]
}
感谢您,Matt
{}
)以使其得到良好的格式化和语法突出显示! - marc_s