Sqlserver XML OpenXML没失去结果集记录

Sqlserver XML OpenXML没得到结果集记录
如下为什么 openxml没得到结果集记录？请大侠帮忙看看

DECLARE @idoc int
DECLARE @doc XML
set @doc ='<MGMsg xmlns="http://www.onlinetest.com/test" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.onlinetest.com/ttest.XSD">
<MsgHdr>
<MsgId>MG-BB02</MsgId>
<MsgMajVsn>1</MsgMajVsn>
<MsgMinVsn>0</MsgMinVsn>
<CrtnDm>16/10/12 14:04</CrtnDm>
<LastProcessedDm>16/10/12 14:04</LastProcessedDm>
<MsgOrgnatorAppl>SYS</MsgOrgnatorAppl>
<MsgGenAddr>PEK-HH</MsgGenAddr>
<LastProcessedBy>SYS</LastProcessedBy>
</MsgHdr>
</MGMsg>'
EXEC sp_xml_preparedocument @idoc OUTPUT,@doc
print @idoc

select * from openxml(@Idoc,'MGMsg/MsgHdr',2)
With( MsgId varchar(10),
MsgMajVsn varchar(20),
MsgMinVsn varchar(20),
CrtnDm varchar(20),
LastProcessedDm varchar(20),
MsgOrgnatorAppl varchar(20),
MsgGenAddr varchar(20),
LastProcessedBy varchar(20)
)
EXEC SP_XML_REMOVEDOCUMENT @idoc

[最优解释]



DECLARE @idoc int
DECLARE @doc XML
set @doc ='&lt;MGMsg &gt;
 &lt;MsgHdr&gt;
  &lt;MsgId&gt;MG-BB02&lt;/MsgId&gt; 
  &lt;MsgMajVsn&gt;1&lt;/MsgMajVsn&gt; 
  &lt;MsgMinVsn&gt;0&lt;/MsgMinVsn&gt; 
  &lt;CrtnDm&gt;16/10/12 14:04&lt;/CrtnDm&gt; 
  &lt;LastProcessedDm&gt;16/10/12 14:04&lt;/LastProcessedDm&gt; 
  &lt;MsgOrgnatorAppl&gt;SYS&lt;/MsgOrgnatorAppl&gt; 
  &lt;MsgGenAddr&gt;PEK-HH&lt;/MsgGenAddr&gt; 
  &lt;LastProcessedBy&gt;SYS&lt;/LastProcessedBy&gt; 
  &lt;/MsgHdr&gt;
&lt;/MGMsg&gt;'
EXEC sp_xml_preparedocument @idoc OUTPUT,@doc
print @idoc

select * from openxml(@Idoc,'MGMsg/MsgHdr',2) 
With( MsgId     varchar(10),
                          MsgMajVsn varchar(20), 
 
                          MsgMinVsn varchar(20),
                          CrtnDm varchar(20),
                          LastProcessedDm varchar(20),
                          MsgOrgnatorAppl varchar(20),
                          MsgGenAddr varchar(20),
                          LastProcessedBy varchar(20)
                          )
EXEC SP_XML_REMOVEDOCUMENT @idoc

[其他解释]
<MGMsg xmlns="http://www.onlinetest.com/test" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.onlinetest.com/ttest.XSD">

有点问题，原因是什么？等待高手！！！

Sqlserver XML OpenXML没失去结果集记

热点推荐