JSON

External Article

Importing JSON Data from Web Services and Applications into SQL Server

  • Article

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.

2017-12-04

4,513 reads

External Article

Consuming hierarchical JSON documents in SQL Server using OpenJSON

  • Article

Over the years, Phil was struck by the problems of reading and writing JSON documents with SQL Server, and wrote several articles on ways of overcoming these problems. Now that SQL Server 2016 onwards has good JSON support, he thought that the articles would be forgotten. Not so, they continue to be popular, so he felt obliged to write about how you can use SQL Server's JSON support to speed the process up.

2017-11-15

3,562 reads

Blogs

The book that made me love goal-setting

By

Pete Wilkinson’s book “Unstoppable” finally made visualizations and goals make sense to me. Here's a...

Daily Coping 16 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Server Query Tuning and Optimization by Benjamin Nevarez

By

I was recently asked to review SQL Server Query Tuning and Optimization by Benjamin...

Read the latest Blogs

Forums

Analyzing execution plan

By dzonibravo96@gmail.com

Hi, can someone help me to understand the following execution plan?  I'm not sure...

#Error for calculation in a textbox

By jeannier175

I am getting the #error when trying to sum a calculated field in ssrs...

how to create index rebuild job on SQL Pas machine

By Diyas

how to create index rebuild job  and stats jobs on SQL Pas machine can...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers