title: How to parse XML data in SQL server table
body: <p>I have SQL table:</p>
  
  <pre><code>Create table
  (
  ID varchar(50) not null,
  Action nvarchar(max) null
  )
  </code></pre>
  
  <p>Action column contains XML data.
  Format: </p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt; 
  &lt;oo_outbound_order&gt;   
           &lt;oo_master&gt;
                &lt;Code&gt;123&lt;/Code&gt;
                &lt;Name&gt;Branan&lt;/Name&gt; 
      &lt;/oo_master&gt; 
      &lt;/oo_outbound_order&gt;
  </code></pre>
  
  <p>How to parse this column? Result should be like this:</p>
  
  <pre><code>CODE    NAME
  123     Branan
  </code></pre>