Tag Archives: SQL to query XML column

SQL- Querying XML attributes from XML Column

Read XML column attributes in to two columns DimType and Dimvalue  from the below example also retrieve the data matching values[DimTypes (WIDTH or Height)]. ‘<dimensions> <dimension name=”width”  value=”12.77″/> <dimension name=”height”  value=”0.14″/> <dimension name=”depth”      value=”12.92″/> </dimenstions>’ Download SQL :-  https://gallery.technet.microsoft.com/SQL-Querying-XML-f700bbb0 … Continue reading

Posted in SQL XML | Tagged , , , | Leave a comment