1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| DECLARE @monDocument XML
SELECT @monDocument = BulkColumn
FROM OPENROWSET(BULK 'C:\Projects\test.xml', SINGLE_CLOB) AS X
INSERT INTO dbo.test
(
col1,
col2,
col3,
col4,
col5,
col6
)
SELECT colonne.value(val1),
colonne.value('./val2[1]', 'TypeDeDonnes'),
colonne.value('./val3[1]', 'TypeDeDonnes'),
colonne.value('./val4[1]', 'TypeDeDonnes'),
colonne.value('./val5[1]', 'TypeDeDonnes'),
colonne.value('./val6[1]', 'TypeDeDonnes')
FROM @monDocument.nodes('/cheminDesValeurs') TMP_XML (colonne) |
Partager