sql
Khóa học miễn phí SQL – JSON Functions nhận dự án làm có lương
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 |
Is used check a string”s validity for JSON (JavaScript Object Notation) syntax. |
| 2 |
Is used create JSON objects from the results of evaluating the SQL expressions of the arguments. |
| 3 |
It accepts an expression or a comma-separated list of expressions and returns a JSON array containing those values. |
| 4 |
It accepts a JSON string and returns a scalar value. |
| 5 |
Is used to extract data from a JSON object. |
| 6 |
Is used to change JSON data kept in a column of a SQL Server table. |
| 7 |
Is used to determine whether a particular JSON route is present within a JSON string. |
Khóa học lập trình tại Toidayhoc vừa học vừa làm dự án vừa nhận lương: Khóa học lập trình nhận lương tại trung tâm Toidayhoc
