DECLARE @XMLToParse XML SET @XMLToParse ='<Animals> <LandAnimals> <Animal>Baboon</Animal> <Animal>Yak</Animal> <Animal>Zebra</Animal> </LandAnimals> </Animals>' DECLARE @ParsingTable TABLE (Animal VARCHAR(100)) INSERT INTO @ParsingTable(Animal) SELECT xmlData.A.value('.', 'VARCHAR(100)') AS Animal FROM @XMLToParse.nodes('Animals/LandAnimals/Animal') xmlData(A) SELECT * FROM @ParsingTable

http://www.sqlserver.info/syntax/parse-xml-with-sql-server/

DECLARE @XMLToParse XML SET @XMLToParse ='<?xml version="1.0" encoding="UTF-8" ?><root><_API type="str">/word/synonyme</_API><source type="str">192.168.80.232</source><def type="str">hello</def><synonymes type="list"><item type="str">hullo</item><item type="str">hi</item><item type="str">howdy</item><item type="str">how-do-you-do</item></synonymes><random_choise type="str">hi</random_choise></root>' DECLARE @ParsingTable TABLE (Animal VARCHAR(100)) INSERT INTO @ParsingTable(Animal) SELECT xmlData.A.value('.', 'VARCHAR(100)') AS Animal FROM @XMLToParse.nodes('root/random_choise') xmlData(A) SELECT * FROM @ParsingTable 17.07.20

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024