Sql查询结果生成指定格式的XML
Sql语句:
SELECT C1701 "@id",C1718 "@fid",C1702 FROM [CenterDataBase].[dbo].[C17] group by C1702,C1701,C1718 order by C1702 asc FOR XML PATH ('str'), ROOT('sorts')
要求生成格式:
<sorts>
<str id="000300030029" fid="00030003">
22.5L弯头
</str>
<str id="000300030030" fid="00030003">
45L弯头
</str>
</sorts>
但实际生成结果为:
<sorts>
<str id="000300030029" fid="00030003">
<C1702>22.5L弯头</C1702>
</str>
<str id="000300030030" fid="00030003">
<C1702>45L弯头</C1702>
</str>
</sorts>
请教各位大人,该如何修改Sql语句?