title: Reading XML in SQL Server of the specified XML node's "name" and get its "value"
body: <p>How can I read the following XML in a SQL Server database:</p>
  <pre><code>&lt;Row&gt;
      &lt;Keys&gt;
        &lt;Key&gt;
          &lt;Name&gt;NAME_2&lt;/Name&gt;
          &lt;Data&gt;22&lt;/Data&gt;
        &lt;/Key&gt;
        &lt;Key&gt;
          &lt;Name&gt;NAME_3&lt;/Name&gt;
          &lt;Data&gt;33&lt;/Data&gt;
        &lt;/Key&gt;
        &lt;Key&gt;
          &lt;Name&gt;NAME_1&lt;/Name&gt;
          &lt;Data&gt;98&lt;/Data&gt;
        &lt;/Key&gt;
      &lt;/Keys&gt;
  &lt;/Row&gt;
  </code></pre>
  <p>I want to select from that XML and get only one row with columns:</p>
  <pre><code>NAME_1, NAME_2, NAME_3.
  </code></pre>
  <p>That's why I need something which would let me to find Keys/Key/Name with the value: NAME_1 and return its Keys/Key/Data, and so on ...</p>
  <p>Expected resultset (1 ROW):</p>
  <pre><code>NAME_1  NAME_2  NAME_3
  -----------------------
     98     22      33
  </code></pre>
  <p>One more important thing. Those values NAME_1, NAME_2, NAME_3. I am expecting them. That's why I need to query for them and return their values for a row.</p>