How to add namespace to sql generated XML output, Sql Server

How to add namespace to sql generated XML output

Language: Layout:

View schema
Execution time: 0,02 sec, rows selected: 1, rows affected: 5, absolute service time: 0,17 sec

edit mode | history | discussion

  
xml_data

1
<Main><ID>1001</ID><details><name>John</name><age>12</age></details></Main><Main><ID>1002</ID><details><name>Rick</name><age>19</age></details></Main><Main><ID>1003</ID><details><name>Diane</name><age>25</age></details></Main><Main><ID>1004</ID><details><name>Kippy</name><age>26</age></details></Main>

λ

                                      .NET NoSQL database for rapid development