title: Format XML returned from SQL for XML
body: <p>Here is my Query : </p>
  
  <pre><code>   select EmployeeName, EmployeeSalary from Employee2
     for xml path('EmployeeDetails')
  </code></pre>
  
  <p>returns</p>
  
  <pre><code>&lt;EmployeeDetails&gt;
    &lt;EmployeeName&gt;xxxxx&lt;/EmployeeName&gt;
    &lt;EmployeeSalary&gt;5000.00000&lt;/EmployeeSalary&gt;
  &lt;/EmployeeDetails&gt;
  </code></pre>
  
  <p>how can i get output as </p>
  
  <pre><code>&lt;EmployeeDetails&gt;
     &lt;EmployeeName = xxxxx /&gt;
     &lt;EmployeeSalary = 5000.00000/&gt;
  &lt;/EmployeeDetails&gt;
  </code></pre>