Convert json to table sql server 2012
Ngày đăng:
01/11/2021
Trả lời:
0
Lượt xem:
77
I am using sql server 2012.I have been assigned a task where one of my column(JsonText) of table(Sample) contain json data.I want to parse that data and insert into columns of another table(Test).I searched on net openjson is supported in sql server 2016.How to do in sql server2012. Table1 : Sample JsonText I am intrested only 'PID,Address,MobileNumber' columns not all. Table Test structure like this What I have tried: I tried with openjson funtion but that is not supported in sql server 2012. |