日期:2014-05-17 浏览次数:20549 次
<priorities tsip:action="new">
<priority tsip:priorityCode="A3" wila:relationCode="DE-IP">
<applicationId>
<number tsip:form="wila">102008031758-6</number>
<number tsip:form="original">10 2008 031 758.6</number>
<number tsip:form="tsip">100031758</number>
<countryCode>DE</countryCode>
<applicationYear>2008</applicationYear>
<date>2008-07-04</date>
</applicationId>
</priority>
</priorities>
SELECT f_content.value('
declare default element namespace "http://schemas.thomson.com/ts/20041221/tsip";
declare namespace tsip = "http://schemas.thomson.com/ts/20041221/tsip";
(/tsip:dataFeed/tsip/memberPatents/patent/priorities/priority/applicationId/number)[1]' ,'nvarchar(MAX)') as PR
from table
SELECT f_content.value('
declare default element namespace "http://schemas.thomson.com/ts/20041221/tsip";
declare namespace tsip = "http://schemas.thomson.com/ts/20041221/tsip";
(/tsip:dataFeed/tsip/memberPatents/patent/priorities/priority/applicationId/number[@tsip:form="original"])[1]' ,'nvarchar(MAX)') as PR
from table