新增文章

文章标题分类内容

select * from T_Meta_ConvertRule where FID = 'SeOrder_PickMtrl';

SELECT 
      a.value('(Name)[1]','varchar(500)') AS FName 
     ,a.value('(SourceEntryKey)[1]','varchar(500)') AS SourceEntryKey 
     ,a.value('(SourceSubEntryKey)[1]','varchar(500)') AS SourceSubEntryKey 
     ,a.value('(TargetEntryKey)[1]','varchar(500)') AS TargetEntryKey 
     ,a.value('(TargetSubEntryKey)[1]','varchar(500)') AS TargetSubEntryKey

,a.value('(FieldMaps)[1]','varchar(max)') AS FieldMaps

from T_Meta_ConvertRule  Cross Apply FKernelXml.nodes('/ConvertRuleMetaData/Rule/ConvertRule/Policies/DefaultConvertPolicy') as node(a)

where  FID = 'SeOrder_PickMtrl'

update T_Meta_ConvertRule 
      set FKernelXml.modify('replace value of (/ConvertRuleMetaData/Rule/ConvertRule/Policies/DefaultConvertPolicy/SourceEntryKey/text())[1] with ("FEntity_CL")')  -- 主单据体

where FID = 'SeOrder_PickMtrl'

update T_Meta_ConvertRule 
      set FKernelXml.modify('replace value of (/ConvertRuleMetaData/Rule/ConvertRule/Policies/DefaultConvertPolicy/SourceSubEntryKey/text())[1] with ("")')  -- 子单据体

where FID = 'SeOrder_PickMtrl'

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
通过XQuery中添加的insert、delete和update关键字提供了对XML DML的支持，使用 insert、delete和update关键字可以分别插入、删除和更新一个或多个节点。例如，在查询窗口中输入以下代码：

UPDATE books 
SET xmlCol.modify('
insert 
<section num="1"> 
 <content>Background</content> 
</section>

after 
(/book/title)[1]

') 
 where id = 1