ScholarLink (思领科)
错误：搜索内容不能为空，请输入英文关键词
错误：关键词超出字数限制，请精简
高级检索

Modifying JSON

  • 章节

  • 发表日期：

    2026年

查看全文
  • Alex Grinberg,
  • Anna Landy

摘要

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.