Native JSON (Java Script Object Notation) support is one of the new feature that is coming with Sql Server 2016.
Introduction to JSON
JSON is simple data representation format, which readable, portable and platform independent. Now JSON is a popular lightweight data-exchange format between the systems. Prior to JSON, web Services used XML as their primary data format for data-interchange. Now JSON is the preferred data-interchange format used by the Web APIs. To know more on JSON you can visit http://json.org/
” : JSON Property Name and value (if it is string) is enclosed within double quotes
: : Colon symbol is used as the separator between the JSON property Name and Value.
{} : Curly braces symbol represents the objects
[,] : Arrays of Value
[{},{}] : Arrays of Objects
To know more on JSON you can visit http://json.org/
JSON In Sql Server 2016
JSON implementation in Sql server is on the similar lines as that of XML. One major difference is: JSON doesn’t have native JSON data type like the XML data type. We can store JSON data in regular NVARCHAR/VARCHAR column.
Below are the main JSON features introduced in Sql Server 2016. Click on the link to understand each of these features with an extensive list of examples.
FOR JSON Clause: can be used to convert the query result (rows) to JSON format.
Indexing Strategy for JSON Value in Sql Server 2016
lax and strict JSON Path modes in Sql Server 2016
[ALSO READ]: