CHAPTER

29

JSON Integration in the Database Engine

In This Chapter

•   An Introduction to JSON

•   Storing JSON Documents in the Database Engine

•   Presenting and Querying JSON Documents

•   Updating JSON Documents

This chapter describes the integration of JavaScript Object Notation (JSON) in the Database Engine. JSON is a data format used to store and transport data. In other words, you use JSON when you want to port data from one computer to another or from one operating system to another operating system.

The first major section introduces JSON and explains its basic concepts. The second section discusses relational storage of JSON documents. The third section discusses presentation and retrieval of data stored in the JSON format. ...

Get Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, 7th Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.