修改XML标头生成 [英] Modifying XML header generation
问题描述
我正在努力实现以下目标:
但
我遇到以下问题
我可以显示一些SQL代码,我用它来生成XML文件的标题部分。
WITH XMLNAMESPACES
(
'http://www.w3.org/2001/XMLSchema -instance'AS xsi
)
SELECT(
SELECT'AMF-XML-Schema.xsd'AS' @ xsi:noNamespaceSchemaLocation',
(SELECT
(选择ICPN AS'EAN'
(SELECT ICPN AS 'EAN'
FROM tbConfiguration cx1
FROM tbConfiguration cx1
WHERE cx1.ConfigurationId = c.ConfigurationId
WHERE cx1.ConfigurationId = c.ConfigurationId
FOR XML路径('itemIdentifier'),TYPE),
FOR XML Path('itemIdentifier'), TYPE),
(SELECT ConfigurationTitle AS Title
(SELECT ConfigurationTitle AS Title
FROM tbConfiguration cx2
FROM tbConfiguration cx2
WHERE cx2.ConfigurationId = c.ConfigurationId
WHERE cx2.ConfigurationId = c.ConfigurationId
FOR XML Path('OriginalLanguage'),ROOT('title'), Type),
FOR XML Path('OriginalLanguage'), ROOT('title'), Type),
有人能指出我正确的方向,我猜我在这里使用了错误的语法。
谢谢
K
推荐答案
查看
http:// www.mombu.com/microsoft/sql-server-xml/t-adding-attributes-to-the-root-element-1111115.html 帮助。
See whether the approach suggested in http://www.mombu.com/microsoft/sql-server-xml/t-adding-attributes-to-the-root-element-1111115.html helps.
这篇关于修改XML标头生成的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!