10 Replies Latest reply: Feb 22, 2013 12:52 PM by Sujith Kumar Matharasi RSS

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

      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?