Read XML File Using SQL Server
DECLARE @XMLValue XML
SET @XMLValue='<Sample>
<Bikes>
<Bike1>Yamaha </Bike1>
<Bike2>Honda</Bike2>
<Bike3>Suzuki</Bike3>
</Bikes>
</Sample>'
SELECTSET @XMLValue='<Sample>
<Bikes>
<Bike1>Yamaha </Bike1>
<Bike2>Honda</Bike2>
<Bike3>Suzuki</Bike3>
</Bikes>
</Sample>'
BI.BIKS.value('Bikes[1]/Bike1[1]','varchar(10)') AS Bike1,
BI.BIKS.value('Bikes[1]/Bike2[1]','varchar(10)') AS Bike2,
BI.BIKS.value('Bikes[1]/Bike3[1]','varchar(10)') AS Bike3
FROM @XMLValue.nodes('Sample') BI(BIKS)
0 comments: