I have to develop a store proc where I will pass a long json string,
I'd like to know what is the better way to insert all the stuff from json fields into a table, that is, to collect all the information
from my json fields and insert into a table that has the same field.
Is there any function in MSSQL that can read json?
I use the MS SQL 2008