SQL - JSON Functions


JSON (JavaScript Object Notation) is a simple format for exchanging data. It is self-descriptive, understandable in any language, and irrespective of language. It serves as an XML substitute. JSON is currently a popular data transfer standard.

The data that returned by modern services is JSON text. SQL Server JSON is the need for data developers to return JSON in SQL. The built-in JSON support in the SQL server is distinct from the native JSON type.

List of Functions

Following is a list of scalar functions that returns information about cursors in the SQL server −

Sr.No. Function & Description
1 ISJSON

Is used check a string's validity for JSON (JavaScript Object Notation) syntax.

2 JSON_OBJECT

Is used create JSON objects from the results of evaluating the SQL expressions of the arguments.

3 JSON_ARRAY

It accepts an expression or a comma-separated list of expressions and returns a JSON array containing those values.

4 JSON_VALUE

It accepts a JSON string and returns a scalar value.

5 JSON_QUERY

Is used to extract data from a JSON object.

6 JSON_MODIFY

Is used to change JSON data kept in a column of a SQL Server table.

7 JSON_PATH_EXISTS

Is used to determine whether a particular JSON route is present within a JSON string.

Advertisements