How to generate xml from SQL with Column Name as prop and Column Value as value MSSQL Server
<p>I have a SQL Table which has the following columns</p>

<ol>
<li><strong>Name</strong></li>
<li><strong>FatherName</strong></li>
<li><strong>MotherName</strong></li>
<li><strong>Nationality</strong></li>
</ol>

<p>I want to generate a XML by SQL Query Which will results as follows</p>

<pre><code>&lt;Customer&gt;
&lt;Prop ID="Name" ValStr="CustName" /&gt;
&lt;Prop ID="FatherName" ValStr="Mr.xxx" /&gt;
&lt;Prop ID="MotherName" ValStr="Mrs.yyy" /&gt;
&lt;Prop ID="Nationality" ValStr="ZZZ" /&gt;
&lt;/Customer&gt;
</code></pre>

<p>How can I get this. Please help me</p>