Research indexBook chapter
Modifying JSON
Grinberg, Landy
Apress eBooks1 Jan 2026
NobleIDark:/48914/w1/20261105/C3A2BD03DOI10.1007/979-8-8688-2803-4_10
Modifying JSON
Grinberg, Landy · Apress eBooks · 2026 · Subscription
NobleIDark:/48914/w1/20261105/C3A2BD03DOI10.1007/979-8-8688-2803-4_10
The full text is at the publisher
You can read the abstract here, or open it at the publisher.
Abstract
To manipulate data within a JSON document, whether inserting, updating, or removing values. SQL Server 2016 introduced the JSON_MODIFY() function. This built-in function updates JSON text directly, but unlike the XML modify() method, it supports only an append operation. The XML counterpart offers a broader set of capabilities, including insert, delete, and replace modes, making JSON_MODIFY() more limited in comparison.