title: How to Insert xml data into SQL Server table?
body: <p>How to import below XML data into SQL Server table with three columns?</p>
  
  <pre><code>&lt;dataset&gt; 
   &lt;metadata&gt;
    &lt;item name="NAME_LAST" type="xs:string" length="62" /&gt; 
    &lt;item name="NAME_FIRST" type="xs:string" length="62" /&gt; 
    &lt;item name="NAME_MIDDLE" type="xs:string" length="32" /&gt;
   &lt;/metadata&gt;
  &lt;data&gt;
  &lt;row&gt;
   &lt;value&gt;SMITH&lt;/value&gt; 
   &lt;value&gt;MARY&lt;/value&gt; 
   &lt;value&gt;N&lt;/value&gt; 
  &lt;/row&gt;
  &lt;row&gt;
   &lt;value&gt;SMITH2&lt;/value&gt; 
   &lt;value&gt;MARY2&lt;/value&gt; 
   &lt;value&gt;N2&lt;/value&gt; 
  &lt;/row&gt;
  &lt;/data&gt;
  &lt;/dataset&gt;
  </code></pre>