| description | JSON Functions (Transact-SQL) | |
|---|---|---|
| title | JSON Functions (Transact-SQL) | Microsoft Docs | |
| ms.custom | ||
| ms.date | 06/03/2020 | |
| ms.prod | sql | |
| ms.technology | t-sql | |
| ms.topic | reference | |
| helpviewer_keywords |
|
|
| ms.assetid | ec97d451-06af-44a3-8304-305d410cfc8e | |
| author | jovanpop-msft | |
| ms.author | jovanpop | |
| ms.reviewer | chadam | |
| 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. |
For more info about the built-in support for JSON in [!INCLUDEssNoVersion], see JSON Data (SQL Server).