title: How to query xml column in tsql
body: <p>I have a table, T1, with a XML column, EventXML, on SQL Server 2008. I want to query all the rows where certain node contains a particular value. Better, I'd like to retrieve the value in a different node. The table T1:</p>
  
  <pre><code>T1:
     EventID, int
     EventTime, datetime
     EventXML, XML
  </code></pre>
  
  <p>Here is an example XML hierarchy:</p>
  
  <pre><code>&lt;Event&gt;
     &lt;Indicator&gt;
        &lt;Name&gt;GDP&lt;/Name&gt;
     &lt;/Indicator&gt;
     &lt;Announcement&gt;
        &lt;Value&gt;2.0&lt;/Value&gt;
        &lt;Date&gt;2012-01-01&lt;/Date&gt;
     &lt;/Announcement&gt;
  &lt;/Event&gt;
  </code></pre>
  
  <ol>
  <li>How to find all the rows related to "GDP" Indicator;</li>
  <li>How to get all values for "GDP" Indicator;</li>
  </ol>