title: SQL Server 2014 get data from JSON column
body: <p>I have a table with many columns, one of them contains JSON structured data,
  for example:</p>
  
  <pre><code>{"firstname": "john", "lastname": "tim"}
  </code></pre>
  
  <p>I need to get all the <code>lastname</code> data.</p>
  
  <p>Any suggestions?</p>