With SQL Server 2016, you can store JSON objects in your rows. Here’s how to work with JSON objects, including how to update them once you’ve found them.

Create a staging table with my primary key field and any arrays of objects Create related tables from each of the arrays in my staging table Plainly, this is going to be a stored procedure and, in the ...

This works great if the JSON file it reads contains an array (2+ items) and correctly appends the new item. However if this tries to read a file with a single item in it, it blows up with this: ...