Posts by evbell • 33 points
3 posts
-
0
votes2
answers116
viewsA: How to return a specific column as an element with FOR XML AUTO clause
They gave me this solution in stackoverflow in English: select Table1.ID, Table1.Nome, Table2.Id, (select table2.DataVencimento for xml path(''), elements, type) from Table1 inner join Table2 on…
-
2
votes2
answers116
viewsQ: How to return a specific column as an element with FOR XML AUTO clause
I need to make a certain column an element in the return xml when I use the FOR XML AUTO clause. Auto-return transforms all fields into attributes of the corresponding element. All right, but either…
-
1
votes1
answer133
viewsQ: How to return a table from xml in sql server
My xml is similar to this: <Operacao Id="1"> <Contatos> <Contato Id="2013"> <Emails> <Email Id="40"/> <Email Id="41"/> </Emails> </Contato>…