Abstract
In Chapter 7, I discussed how we can convert relational data into JSON documents, but what if we had to shred a JSON document (just as you learned to shred XML documents in Chapter 4) into a relational dataset? We could achieve this by using the OPENJSON() function. The OPENJSON() function accepts a single JSON document as an input parameter and outputs a tabular result set. The OPENJSON() function can be called either with or without specifying an explicit schema for the result set. OPENJSON() also supports the use of JSON path expressions. This chapter will examine each of these options.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsAuthor information
Authors and Affiliations
Rights and permissions
Copyright information
© 2018 Peter A. Carter
About this chapter
Cite this chapter
Carter, P.A. (2018). Shredding JSON Data. In: SQL Server Advanced Data Types. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-3901-8_8
Download citation
DOI: https://doi.org/10.1007/978-1-4842-3901-8_8
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-3900-1
Online ISBN: 978-1-4842-3901-8
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books