| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | dev_langs | ms.custom | monikerRange | |||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
JSON Functions (Transact-SQL) |
Use JSON functions to validate or change JSON text, or to extract simple or complex values. |
WilliamDAssafMSFT |
wiassaf |
jovanpop, randolphwest |
08/20/2024 |
sql |
t-sql |
reference |
|
|
|
=azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric |
[!INCLUDE sqlserver2016-asdb-asdbmi-asa-fabricse-fabricdw]
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 [!INCLUDE ssNoVersion], see JSON data in SQL Server.