Question

页: 1

<EntityKey_x005B__x005D_>
  <EntityKey>
    <KeyData xmlns="http://schemas.microsoft.com/dynamics/2006/02/documents/EntityKey">
      <KeyField>
        <Field>JournalNum</Field>
        <Value>LJRN000071</Value>
      </KeyField>
    </KeyData>
  </EntityKey>
  <EntityKey>
    <KeyData xmlns="http://schemas.microsoft.com/dynamics/2006/02/documents/EntityKey">
      <KeyField>
        <Field>JournalNum</Field>
        <Value>LJRN000072</Value>
      </KeyField>
    </KeyData>
  </EntityKey>
  <EntityKey>
    <KeyData xmlns="http://schemas.microsoft.com/dynamics/2006/02/documents/EntityKey">
      <KeyField>
        <Field>JournalNum</Field>
        <Value>LJRN000073</Value>
      </KeyField>
    </KeyData>
  </EntityKey>
  <EntityKey>
    <KeyData xmlns="http://schemas.microsoft.com/dynamics/2006/02/documents/EntityKey">
      <KeyField>
        <Field>JournalNum</Field>
        <Value>LJRN000074</Value>
      </KeyField>
    </KeyData>
  </EntityKey>
</EntityKey_x005B__x005D_>

但是,由于<条码>xmlns=......,我似乎无法从中选择《日刊》的数值。在互联网上,我可以做一些事情,如<条码>{>。 http://schemas.microsoft.com/dynamics/2006/02/documents/EntityKey}KeyData“,以检索,但我在LQ中发现一个星号错误。

我只想获得一份价值节点清单,以便列入一个温床,而这要么没有工作。

SELECT  IDENTITY(int,1,1) as  ID ,
    c.query( (KeyData/KeyField/Value)[1] ) as  JournalNum 
INTO    #tmpBatches
FROM    @ResultData.nodes( //EntityKey ) t(c)

想法? 建议解决办法?

Answer 1

......当然,在提出要求后正确

    ;WITH XMLNAMESPACES (N http://schemas.microsoft.com/dynamics/2006/02/documents/EntityKey  as DYN)
    SELECT  IDENTITY(int,1,1)   
                as  ID ,
            c.value( (DYN:KeyData/DYN:KeyField/DYN:Value)[1] ,  VARCHAR(40) )
                as  JournalNum 
    INTO    #tmpBatches
    FROM    @ResultData.nodes( //EntityKey ) t(c)

Answer 2

由于你只有一个名字空间,你本可以利用儿童之友协会避免在任何地方预先确定:

 ;WITH XMLNAMESPACES (DEFAULT N http://schemas.microsoft.com/dynamics/2006/02/documents/EntityKey ) 
        SELECT   IDENTITY(int,1,1)                                                
        as  ID , c.value( (<strike>DYN:</strike>KeyData/DYN:KeyField/DYN:Value)[1] ,  VARCHAR(40) )
        as  JournalNum 
            INTO #tmpBatches
        FROM @ResultData.nodes( //EntityKey ) t(c)

Also, some notes I stumbled across on how to ignore all namespaces for when there are more than one and you KNOW you will have no collisions. Someone s blog.

友情链接