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>

...