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.