Blog Post

SQL Server Blog
2 MIN READ

Upsert JSON documents in SQL Server 2016

JovanPop's avatar
JovanPop
Icon for Microsoft rankMicrosoft
Mar 23, 2019
First published on MSDN on Mar 03, 2016 In Sql Server 2016 you can easily insert or update JSON documents by combining OPENJSON and MERGE statement. In this example I will creat...
Updated Mar 23, 2019
Version 2.0
SQLServerStorageEngine
CodeBill's avatar
CodeBill
Copper Contributor
Oct 12, 2021

Thanks for posting this article, I'm surprised this user case hasn't been mentioned more on the tech community and MSDN bulletins considering pretty much everyone is working with JSON data these days!

Anyway it saved me some time in trying to figure out the syntax when using OPENJSON with MERGE statements, so thanks a million 👍🏼