Xml can be generated in SQL server many different ways and it is not always straightforward
Requirement:
Generate elements with same names and some data as attributes and some as element inner text.
Example:
<document>
<fields>
<field name="Field_1" type="Field1">Field1 Value</field>
<field name="Field_2" type="Field2">Field2 Value</field>
</fields>
</document>
Query:
select TOP 1
'Field1' 'field/@type',
'Field_1' 'field/@name',
Field1Value AS 'field',
'',
'Field2' 'field/@type',
'Field_2' 'field/@name',
Field2Value AS 'field',
''
from Invoice as tbl1
for xml path('fields'), type, Root('Document')
http://stackoverflow.com/questions/25412429/sql-server-generating-xml-with-generic-field-elements
No comments:
Post a Comment