title: How to create XML file by SQL query?
body: <p>I have a <code>Select</code> query which selects the top 10 values from table</p>
  
  <pre><code>Create proc [dbo].[SP_Select_Top10]
  as
     select DISTINCT top (10)
         Score, FBid 
     from 
         FB_Player 
     ORDER BY 
         Score DESC
  </code></pre>
  
  <p>What I need is to have the results of this query in <strong>xml</strong> file as.</p>
  
  <pre><code>&lt;player&gt;
      &lt;name&gt; &lt;/name&gt;
      &lt;score&gt; &lt;/score&gt;
  &lt;/player&gt;
  </code></pre>
  
  <p>I use ASP.NET to create this file how can I do that ?</p>