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