title: SQL Server XML parsing first node attributes
body: <p>I have a XML column in database that may look like that ones:</p>
  
  <pre><code>&lt;sql-connection-info name="myname" server="(local)\SQLEXPRESS" other-attribute="value" /&gt;
  
  &lt;oracle-connection-info name="othername" server="address" other-attribute="value" /&gt;
  </code></pre>
  
  <p>and so on. The names of nodes and attributes can be nearly anything. I need to iterate over the attribute/value pair on the first node. Every sample I have seen was for known node/attribute names. </p>
  
  <p>When I tried to use </p>
  
  <pre><code>@xmlColumn.query("/@*")
  </code></pre>
  
  <p>I get this error</p>
  
  <blockquote>
    <p>XQuery [query()]: Top-level attribute nodes are not supported.</p>
  </blockquote>
  
  <p>Is this possible in TSQL? If yes how can I do this?</p>