Click here to Skip to main content
15,895,746 members
Articles / Programming Languages / SQL

Inserting JSON Text into SQL Server Table

Rate me:
Please Sign up or sign in to vote.
4.86/5 (29 votes)
26 Mar 2016CPOL7 min read 294.5K   1.3K   35  
How to easily insert array of JSON objects into SQL Server 2016 tables
In this article, we will see how you can use OPENJSON function to insert array of JSON object into table.

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Program Manager Microsoft
Serbia Serbia
Graduated from Faculty of Electrical Engineering, Department of Computer Techniques and Informatics, University of Belgrade, Serbia.
Currently working in Microsoft as Program Manager on SQL Server product.
Member of JQuery community - created few popular plugins (four popular JQuery DataTables add-ins and loadJSON template engine).
Interests: Web and databases, Software engineering process(estimation and standardization), mobile and business intelligence platforms.

Comments and Discussions