Torna al Thread
use DB
--carico l'intero doc xml in una var
declare @xmltry as xml
set @xmltry =(
select Q.BULKCOLUMN
from openrowset(bulk 'C:\articoli.xml', single_clob) as Q
);
declare @hdoc int
exec sp_xml_preparedocument @hdoc output, @xmltry;
select *
from openxml (@hdoc, '/Articoli/Articolo/Num/Catcod/Catdes/Lincod/Lindes/Blecod/Bledes/Eticod/Etides/Artcod/Artdes', 1)
with (Num bigint '@Num',
Catcod varchar(20) '@Catcod',
Catdes varchar(50) '@Catdes',
Lincod varchar(20) '@Lincod',
Lindes varchar(50) '@Lindes',
Blecod varchar(20) '@Blecod',
Bledes varchar(50) '@Bledes',
Eticod varchar(20) '@Eticod',
Etides varchar(50) '@Etides',
Artcod varchar(20) '@Artcod',
Artdes varchar(50) '@Artdes'
);
exec sp_xml_removedocument @hdoc;