Import JSON string to SQL tabular row-column format

Import JSON string to SQL tabular row-column format

#JSONwithSQL #SQLServer #SQLwithManoj

[sasidharmodepalli]

In case if we don’t know how many nested arrays are present in one single column with json format, in this case how can we achieve to separate the columns

[suryadandes]

with version of SQL you use?
I'm usig SQL server 12.0, it doesn't work.

[ujjwalshrivastava]

what if the query is like {
//something written on it

}

what we will do $.?what

[gangakeerthi]

What if the json doesnot have column names

[mayurjain]

How to use JSON_VALUE for inputs(JSON format) containing no root