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;
Copyright © dotNetHell.it 2002-2025
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5