title: Extract json object data in SQL Server
body: <p>I have a table in which a columns contains data in json object</p>
  <pre><code>[
      { &quot;Name&quot;:&quot;no note&quot;,
        &quot;Code&quot;:&quot;no note&quot;,
        &quot;Note&quot;:&quot;&quot;,
        &quot;Description&quot;:&quot;no note&quot;
      }, 
      { 
         &quot;Name&quot;:&quot;sfsdfs&quot;,
         &quot;Code&quot;:&quot;sfdsfsdf&quot;,
         &quot;Note&quot;:&quot;fsdfsdf&quot;,
         &quot;Description&quot;:&quot;sfdfdsfdsfsdf&quot;
      }
  ]
  </code></pre>
  <p>I have to extract data from these objects and insert into a temptable along with some primary value Like <code>EntryId</code></p>
  <pre><code>EntryId | Name | Note | Description
  </code></pre>
  <p>Please suggest any solution. Thanks in advance.</p>