title: Query JSON inside SQL Server 2012 column
body: <p>I have a column inside my SQL Server 2012 table which contains following Json data.</p>
  
  <pre><code>[{"bvin":"145a7170ec1247cfa077257e236fad69","id":"b06f6aa5ecd84be3aab27559daffc3a4"}]
  </code></pre>
  
  <p>Now I want to use this column data in my query like</p>
  
  <pre><code>select * 
  from tb1 
  left join tb2 on tb1.(this bvin inside my column) = tb2.bvin.
  </code></pre>
  
  <p>Is there a way to query JSON data in SQL Server 2012?</p>