Import an XML to two tables in SQL Server

0

I have a XML that exports two tables, now that XML I want to import it to another table with the same fields, they are too much data that is why I exported it, I hope you can help me thanks.

This is my query

SELECT * FROM usuario INNER JOIN vehiculo on usuario.id = vehiculo.usuario_id
where usuario.id between 1 and 2
FOR XML raw,elements,root('xml')

Then that XML I have to pass again to another database that have the same two tables with the same columns.

thanks.

    
asked by Erika G. Abril Duarte 27.04.2018 в 19:52
source

0 answers