Редагувати

Поділитися через


JSON functions (Transact-SQL)

Applies to: SQL Server 2016 (13.x) and later Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric

Use the functions described in this article support querying, manipulating, and construction JSON data. Use JSON functions to validate or change JSON documents, or to extract basic or complex values.

Function Description
ISJSON Tests whether a string contains valid JSON.
JSON_ARRAY Constructs JSON array text from zero or more expressions.
JSON_ARRAYAGG Constructs a JSON array from an aggregation of SQL data or columns.
JSON_MODIFY Updates the value of a property in a JSON string and returns the updated JSON string.
JSON_OBJECT Constructs JSON object text from zero or more expressions.
JSON_OBJECTAGG Constructs a JSON object from an aggregation of SQL data or columns.
JSON_PATH_EXISTS Tests whether a specified SQL/JSON path exists in the input JSON string.
JSON_QUERY Extracts an object or an array from a JSON string.
JSON_VALUE Extracts a scalar value from a JSON string.
OPENJSON Parses JSON text and returns objects and properties from the JSON input as rows and columns.

For more info about the built-in support for JSON in SQL Server, see JSON data in SQL Server.