sql - 如何选择属性名称 (fn :local-name() with xquery

Question

此查询 select @x.query('data(realm/roles/role[4]/@*[2])') 针对此 xml(

<realm name="ACP" context="Expresslane">
  <roles>
    <role name="Administrator" />
    <role name="elUser" />
    <role name="ElAdministrator" />
    <role name="regionalManager" justtest="aaa">
      <constraints>
        <constraint name="CustomerList" mode="Select">
          select * from BaanEl.com010nnn where t$cuno in(select * from baanEl.ftPriceListCustomers(&lt;%=comno%&gt;,&lt;%cpls%&gt;))
        </constraint>
      </constraints>
    </role>
    <role name="Rep" />
    <role name="DiscountAdministrator" />
    <role name="LoginAdmin">
      <realm url="http://localhost/PriceWorx_Sandbox/Default.aspx#tabs-2" visible="true" enabled="true" />
    </role>
  </roles>
  <rolegroups>
    <rolegroup name="Administrators">
      <member name="Administrator" />
      <memeber name="elUser" />
      <member name="elAdministrator" />
      <member name="regionalManagee" />
      <member name="Rep" />
      <member name="DiscountAdministrator" />
      <member name="LoginAdmin" />
    </rolegroup>
  </rolegroups>
</realm

) returns proper attribute value..

如何获取同一属性的名称(本地名称)？

Answer 1

试试这个:

SELECT  
  name = @x.query('local-name((realm/roles/role[4]/@*[2])[1])')
, val  = @x.query('data(realm/roles/role[4]/@*[2])')

/* -- OUTPUT
 name      val
 justtest  aaa
*/