I have a query:
我有一个问题:
insert into #tmpRcIzm
select distinct
v.id_art, 'Y'
from
openxml(@hDoc, '/art_komp/nol') with #vc xd
inner join nol v on xd.id_art = v.id_art
where
xd.P_REF!=v.P_REF
Is it possible to get the xml file name from it? If yes, then how it is done?
是否可以从中获取xml文件名?如果是,那么它是如何完成的?
1 个解决方案
#1
1
XML is a string and carries no information about what file it was previously stored in.
You have to provide the filename to SQL Server in some other way.
XML是一个字符串,不包含有关以前存储的文件的信息。您必须以其他方式向SQL Server提供文件名。
#1
1
XML is a string and carries no information about what file it was previously stored in.
You have to provide the filename to SQL Server in some other way.
XML是一个字符串,不包含有关以前存储的文件的信息。您必须以其他方式向SQL Server提供文件名。