CODEWITHSUNDEEP
sqlxmlsql-server-2005
Brezhnews
Brezhnews

Reputation: 1569

How to get xml file name from query?

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?

Upvotes: 0

Views: 337

Answers (1)

Mikael Eriksson
Mikael Eriksson

Reputation: 138980

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.

Upvotes: 1

Related Questions