Exportar SQL a XML

[Libras]

Tabla t_sm_ge_Menu
id description url_code
1 Manager 1
2 Security Metrics 1
3 Submit Metrics 2
4 Metrics Catalog 3
5 Exceptions 4
6 Security Operations 5
7 Report Console 6
8 Assets 7
9 Business Dashboards 8

Código SQL:

SELECT * FROM dbo.t_sm_ge_Menu
FOR XML raw,elements,root('xml')
 

Resultado:

Código XML:

<xml>
  <row>
    <id>1</id>
    <description>Manager</description>
    <url_code>1</url_code>
  </row>
  <row>
    <id>2</id>
    <description>Security Metrics</description>
    <url_code>1</url_code>
  </row>
  <row>
    <id>3</id>
    <description>Submit Metrics</description>
    <url_code>2</url_code>
  </row>
  <row>
    <id>4</id>
    <description>Metrics Catalog</description>
    <url_code>3</url_code>
  </row>
  <row>
    <id>5</id>
    <description>Exceptions</description>
    <url_code>4</url_code>
  </row>
  <row>
    <id>6</id>
    <description>Security Operations</description>
    <url_code>5</url_code>
  </row>
  <row>
    <id>7</id>
    <description>Report Console</description>
    <url_code>6</url_code>
  </row>
  <row>
    <id>8</id>
    <description>Assets</description>
    <url_code>7</url_code>
  </row>
  <row>
    <id>9</id>
    <description>Business Dashboards</description>
    <url_code>8</url_code>
  </row>
</xml>
 

Saludos!