SQL Server JSON - Check if field exists by name

3lxsmp7m 于 2023-03-17 发布在其他

关注(0)|答案(1)|浏览(110)

I have a field name stored in the database. I would like to check if this field exists in my JSON in Angular 13 app. In XML I would do this: myXmlDoc.SelectSingleNode("/My_RootNode/id") Is it possible with JSON?

sql-server

来源：https://stackoverflow.com/questions/75745697/json-check-if-field-exists-by-name

1条答案

按热度按时间

zbq4xfa01#

You can do this using JSON_VALUE directly in SQL Server.

SELECT *
FROM YourTable
WHERE JSON_VALUE(YourJson, '$.My_RootNode.id') IS NOT NULL;

If the id property is actually an object or array (as opposed to scalar) then use JSON_QUERY

WHERE JSON_QUERY(YourJson, '$.My_RootNode.id') IS NOT NULL;

In SQL Server 2022 you can use JSON_PATH_EXISTS for both cases

WHERE JSON_PATH_EXISTS(YourJson, '$.My_RootNode.id') = 1;

赞(0）回复(0）举报 2023-03-17

我来回答

SQL Server JSON - Check if field exists by name

1条答案

相关问题

热门标签

最新问答