Sinan EGE

Sinan EGE

  • NA
  • 8
  • 13.9k

SQL XML Column Select

Nov 13 2013 4:07 PM
How the select all value xml column ?
<WeatherReturn xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://ws.cdyne.com/WeatherWS/"><Success>true</Success><ResponseText>City Found</ResponseText><State>AL</State><City>Billingsley</City><WeatherStationCity>Montgomery</WeatherStationCity><WeatherID>11</WeatherID><Description>Clear</Description><Temperature>47</Temperature><RelativeHumidity>83</RelativeHumidity><Wind>CALM</Wind><Pressure>30.19F</Pressure><Visibility /><WindChill /><Remarks /></WeatherReturn>

Answers (4)