| 1 | ISJSON | This function is used to check whether a string contains valid JSON or not. |
| 2 | JSON_ARRAY | This function is used to constructs JSON array text from zero or more expressions. |
| 3 | JSON_ARRAYAGG | This is used to constructs a JSON array from an aggregation of SQL data or columns. |
| 4 | JSON_MODIFY | This function will updates the value of a property in a JSON string and returns the updated JSON string. |
| 5 | JSON_OBJECT | This function is used to constructs JSON object text from zero or more expressions. |
| 6 | JSON_OBJECTAGG | This function is used to constructs a JSON object from an aggregation of SQL data or columns. |
| 7 | JSON_PATH_EXISTS | This function is mainly used to test wheather specified SQL/JSON path exists in the input JSON string. |
| 8 | JSON_QUERY | This function is used to extracts an object or an array from a JSON string. |
| 9 | JSON_VALUE | This function is used to extracts a scalar value from JSON string. |
| 10 | OPENJSON | This function is used to parses JSON text and returns objects and properties from the JSON input as rows and columns. |