I played with it a little bit and it didn't exhibit any weirdness for me.<BR><BR>As far as the existing test goes, I would assume that SQL detaches and deletes it when you have it set to overwrite ...

Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.

Use a DSN-less connection (i.e. with no data source defined on the server) to connect the program to your database for simplicity. You will need to use HTML to format the data.