title: How to insert from XML file into SQL server?
body: <p>How to insert from XML file into SQL Server if the format of file is like this?</p>
  
  <p>I want columns <code>Description</code>, <code>Alias</code>, and <code>Name</code>.</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  
  &lt;!DOCTYPE ldmlBCP47 SYSTEM "../../common/dtd/ldmlBCP47.dtd"&gt;
  &lt;ldmlBCP47&gt; 
     &lt;version number="$Revision: 6625 $"/&gt; 
     &lt;generation date="$Date: 2012-03-01 15:01:04 -0800 (Thu, 01 Mar 2012) $"/&gt; 
     &lt;keyword&gt; 
        &lt;key description="Time zone key" alias="timezone" name="tz"&gt; 
           &lt;type description="Andorra" alias="Europe/Andorra" name="adalv"/&gt; 
           &lt;type description="Dubai, United Arab Emirates" alias="Asia/Dubai" name="aedxb"/&gt; 
           &lt;type description="Kabul, Afghanistan" alias="Asia/Kabul" name="afkbl"/&gt; 
           &lt;type description="Antigua" alias="America/Antigua" name="aganu"/&gt; 
           &lt;type description="Anguilla" alias="America/Anguilla" name="aiaxa"/&gt; 
           &lt;type description="Tirane, Albania" alias="Europe/Tirane" name="altia"/&gt; 
  </code></pre>