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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial