title: Selecting XML Data from SQL query - No values returned
body: <p>Xml Column returns no rows.<br>
  Below created a table type and xml value inserted into that table. After             executing the below mentioned two queries no value is returned.<br>
  Xml data is a valid data.</p>
  
  <pre><code>DECLARE @Test TABLE (Id INT IDENTITY (1,1), XMLDATA XML)
  
  INSERT INTO @test
  SELECT '
  &lt;TXLife xmlns="http://ACORD.org/Standards/Life/2" xmlns:tx="http://ACORD.org/Standards/Life/2" Version="2.20.00"&gt;
      &lt;TXLifeRequest PrimaryObjectID="Holding_1"&gt;
          &lt;CorrelationGUID&gt;4b30545a-158b-441a-a37a-0b259f757059&lt;/CorrelationGUID&gt;
      &lt;/TXLifeRequest&gt;
  &lt;/TXLife&gt;'
  
  SELECT 
        Id
      , XMLDATA.query('//CorrelationGUID') AS 'TransType'
      , XMLDATA
  FROM @test
  
  SELECT C.value('./CorrelationGUID[1]', 'varchar(50)') AS 'TransType'
  FROM @test
  CROSS APPLY XMLDATA.nodes('/TXLife/TXLifeRequest') n (C)
  </code></pre>