title: Convert XML column to Table Data in SQL Query
body: <p>I have this XML file which is a returned data table from web service:</p>
  
  <pre><code>        DECLARE @MyXML XML = 
          '&lt;?xml version="1.0" encoding="utf-8"?&gt;
          &lt;DataTable xmlns="http://tempuri.org/"&gt;
            &lt;xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"&gt;
              &lt;xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="Blah" msdata:UseCurrentLocale="true"&gt;
                &lt;xs:complexType&gt;
                  &lt;xs:choice minOccurs="0" maxOccurs="unbounded"&gt;
                    &lt;xs:element name="Blah"&gt;
                      &lt;xs:complexType&gt;
                        &lt;xs:sequence&gt;
                          &lt;xs:element name="Col1" type="xs:string" minOccurs="0" /&gt;
                        &lt;/xs:sequence&gt;
                      &lt;/xs:complexType&gt;
                    &lt;/xs:element&gt;
                  &lt;/xs:choice&gt;
                &lt;/xs:complexType&gt;
              &lt;/xs:element&gt;
            &lt;/xs:schema&gt;
            &lt;diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1"&gt;
              &lt;DocumentElement xmlns=""&gt;
                &lt;Blah diffgr:id="Blah1" msdata:rowOrder="0" diffgr:hasChanges="inserted"&gt;
                  &lt;Col1&gt;testing1&lt;/Col1&gt;
                &lt;/Blah&gt;
              &lt;/DocumentElement&gt;
            &lt;/diffgr:diffgram&gt;
          &lt;/DataTable&gt;'
  </code></pre>
  
  <p>I want an output like this:
     Select Col1</p>
  
  <p>Col1</p>
  
  <hr>
  
  <p>testing1</p>
  
  <p>Then, I would be able to insert the data into a table in sql.</p>