Inserting JSON Text into SQL Server Table

Inserting JSON Text into SQL Server Table:
SQL Server 2016 and Azure SQL Database have a new function OPENJSON that enables you to easily parse JSON text and insert it into any database table. In this video we will see how you can use this function to insert array of JSON object into table.

Before this features, we had to parse this JSON using JSON.Net or some other serializer or use frameworks to map JSON into objects and then store them into database using ADO.NET or Entity Framework.
You can insert the data into the table using SQL stored procedure.

With SQL Server 2016, you have another alternative - just send the entire JSON text to database and parse it using new OPENJSON function.

#insert JSON string value into SQL database
#Inserting JSON Text into SQL Server Table
#insert JSON in DB Table directly.