Documentation › JSON Data Type
JSON Data Type
Use within scripts or in a table to store a parsed JSON obect graph.
The JSON data type holds a parsed object representation of the JSON string it was created with. It has functions that are similar to the stand-alone functions, for example the dbo.JsonInt(data, query) function has the JSON data type equivalent QueryInt(query).
The JSON data type is suitable for use in scripts, stored procedures etc. where it allows you to parse JSON once and query it multiple times. It's use for persistent storage is not necessarily recommended, as depending on the size and complexity of your JSON, parsing using the stand-alone functions can be quicker than saving and retrieving the JSON data type's binary format.
|Line 0 Quantity||Line 1 Quantity||Total Count|