How to parse json data in SQL Server 2012?
<p>I am using SQL Server 2012.I have been assigned a task where one of my column (<code>JsonText</code>) of table <code>Sample</code> contains json data. I want to pass parse that data and insert into columns of another table (<code>Test</code>). I searched on net 'openjson' is supported in SQL Server 2016. How to do in SQL Server 2012?</p>

<p>Table1 : Sample</p>

<pre><code>Id JsonText Active 
</code></pre>

<p>JsonText</p>

<pre><code>webaddress?{'data':'{"PId": "XXXX","Status": "YES","Name":"XXX","Address":"XXXX","MobileNumber":"xxx"}'}
</code></pre>

<p>I am intrested only 'PID,Address,MobileNumber' columns not all.</p>

<p>Table Test structure like this</p>

<pre><code>Id, PID, Address, MobileNumber
</code></pre>