Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Tuesday, December 12, 2017

Importing JSON Data from Web Services and Applications into SQL Server

SQLServerCentral.com Articles
Importing JSON Data from Web Services and Applications into SQL Server

To support many applications, it makes sense for the database to work with JSON data, because it is the built-in way for a JavaScript or TypeScript application to represent object data. It can mean less network traffic, looser coupling, and less need for the application developer to require full access to the base tables of the database. However, it means that the database must do plenty of checks first before importing. Phil Factor explains how it can be easily done.

No comments: