How-To Fetch/parse XML fields from a MS SQL database

[#1]

Hi,

I'm trying something and I don't know if it is possible.

I have a MS SQL database with only 1 table containing XML fields, which look like this

<Personnel>

          <Employee>

                    <Name>17fnle4mqwvoc</Name>

                    <ID>1</ID>

                    <Age>55</Age>

                    <Gender>Male</Gender>

          </Employee>

</Personnel>

I want to load these XML's from the database and parse them like normal XML.

Is this possible, and how?

[#2]

Hi Garbiel,

Did you find the solution for this?I am also looking for something similar to this one.

If you do please help me .

Thanks