| title | JSON Functions (Transact-SQL) | |
|---|---|---|
| description | JSON Functions (Transact-SQL) | |
| author | jovanpop-msft | |
| ms.author | jovanpop | |
| ms.date | 06/03/2020 | |
| ms.prod | sql | |
| ms.technology | t-sql | |
| ms.topic | reference | |
| ms.custom | event-tier1-build-2022 | |
| helpviewer_keywords |
|
|
| dev_langs |
|
|
| monikerRange | = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || >= sql-server-linux-2017 |
[!INCLUDE sqlserver2016-asdb-asdbmi-asa]
Use the functions described on the pages in this section to validate or change JSON text or to extract simple or complex values.
| Function | Description |
|---|---|
| ISJSON | Tests whether a string contains valid JSON. |
| JSON_VALUE | Extracts a scalar value from a JSON string. |
| JSON_QUERY | Extracts an object or an array from a JSON string. |
| JSON_MODIFY | Updates the value of a property in a JSON string and returns the updated JSON string. |
| JSON_PATH_EXISTS | Tests whether a specified SQL/JSON path exists in the input JSON string. |
For more info about the built-in support for JSON in [!INCLUDEssNoVersion], see JSON Data (SQL Server).