Re: Query an xml column

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



The table is named CAR with a column called BaseData with the
following entry for a single column

Car

id - 11
color - red
BaseData - <BaseData xmlns:xsi="http://www.w3.org/2001/XMLSchema-
instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema";
xsi:type="CarData"><RentalCars>123</RentalCars><LeaseCars>22</
LeaseCars><JunkCars>5</JunkCars></BaseData>


Hope this is clear
Thanks for the help
.