This chapter explored JSON support in SQL Server 2016. It is not as robust and deep as is the case with XML---there is no native data type, no optimized storage, and therefore you cannot create JSON indexes to improve performance. Thus, we are talking about built-in and not native JSON support.
However, even with built-in support, it is easy and handy to integrate JSON data in SQL Server. For most of JSON data processing, it would be acceptable. For large JSON documents stored in large database tables, it would be more appropriate to use DocumentDB or other NoSQL based solutions.
In this chapter, you learned the following topics:
SQL Server 2016 brings built-in support for JSON data; unlike XML, there is no native data type
Use the
FOR JSON
extension to generate JSON from data in a tabular formatConverting JSON data into a tabular format by using the
OPENJSON
rowset functionParsing, querying, and modifying JSON data with a function
Improving the performance of JSON data processing by...