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 ...

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.

Learn about JavaScript Object Notation and JSON objects and arrays, including how and why they're used. Also, find out how JSON compares to HTML and XML.

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: ...