title: How to parse json data in SQL Server 2012?
body: <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>