Home Forums Programming XML Query to select records from Xml column RE: Query to select records from Xml column

  • Hello Expert,

    Same above scenario i have...i have a table in which one column xmldata(having datatype xml) contain data in xml format, as given below:

    <Employee>

    <EMPID>1</EMPID>

    <EMPNAME>AAA</EMPNAME>

    <EMPSALARY>2000.00</EMPSALARY>

    <DEPTID>1</DEPTID>

    </Employee>

    Now i have to read this xml data and display it with respective column names..like

    EMPID EMPNAME EMPSALARY DEPTID

    1 AAA 2000.00 1

    please help..

    Thanks in advance...

    reagrds,

    Avi