Abstract
To insert, delete, and update data in a JSON document, SQL Server 2016 introduced the JSON_MODIFY() function that updates a JSON string value. This function, compared to XML modify() method, only has an append mode, as opposed to the insert, delete, and instead of modes provided by the XML method. Chapter 10 “Modifying JSON” will demonstrate many recipes explaining how to update a JSON document. In the final section of this chapter, I will compare the performance between XML and JSON.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2018 Alex Grinberg
About this chapter
Cite this chapter
Grinberg, A. (2018). Modifying JSON. In: XML and JSON Recipes for SQL Server. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-3117-3_10
Download citation
DOI: https://doi.org/10.1007/978-1-4842-3117-3_10
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-3116-6
Online ISBN: 978-1-4842-3117-3
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)