Category Archives: SQL XML

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 →