I found this example on
http://www.ibiblio.org/xml/slides/sd2000west/xmlandjava/221.html <?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl
utput method="text"/>
<xsl:template match="Row">
INSERT INTO composers (
<xsl:apply-templates select="Field" mode="names"/>
)
VALUES (
<xsl:apply-templates select="Field" mode="values"/>
)
</xsl:template>
<xsl:template match="Field" mode="values">
'<xsl:value-of select="."/>'<xsl:if test="position()!=last()">, </xsl:if>
</xsl:template>
<xsl:template match="Field" mode="names" >
'<xsl:value-of select="@name"/>'<xsl:if test="position()!=last()">, </xsl:if>
</xsl:template>
</xsl:stylesheet>