Generate XML from mssql2005

**MacW** · 01-09-2008, 08:15 AM

I want to create a procedure that generates the following format for a XML response.

<row>
<field name="nr">99</field>
<field name="namn">test bolag</field>
</row>
<row>
<field name="nr">98</field>
<field name="namn">test bolag 2</field>
</row>

**Learning Newbie** · 01-09-2008, 02:25 PM

Well if you don't want to do SELECT FOR XML and use XSLT, you could do

SELECT '<row>' + chr(13) + '<field name='nr'>' + nr + '</field>' and so on.

**MacW** · 01-11-2008, 10:23 AM

And if I want to use FOR XML, is there a way to alter the tags?