In this tutorial you will jSON to SQL , how to import JSON data into SQL Server.
JSON data structure is widely used in various applications because of easy compatibility to consume in different format, now here we learn how we can import json data into SQL table directly.
Here is how the json data structure will look like!
{"students":[ {"fullname":"Akansha Kulkarni", "contact":"9852100001"}, {"fullname":"Arunavo Chaterjee", "contact":"9852100002"}, {"fullname":"Shanthi Gopalan", "contact":"9852100003", {"fullname":"Prajakta Shah", "contact":"9852100004"} ]}
If you are not familiar with how json data structure will look like, read this json tutorial.
We have json support in sql server 2016 and later version , here is an complete example of how to work with json data in sql server
SELECT * FROM [dbo].[tbStock] FOR JSON PATH;
Like sql xml command, we also have "FOR JSON PATH" and "FOR JSON Auto".
SQL Server 2012 does not support json commands, to use “for json path” you need to have upper version like SQL Server 2019.
There are few tools available online, which can help creating sql query from json data.
You may be interested to read following posts: