Not like that i am asking that , i want insert the XML File data

into table records.

Ex :

<countryData>

<Country>

<CName>AMERICAN SAMOA</CName>

<CCode>AS</CCode>

</Country>

<Country>

<CName>ANDORRA</CName>

<CCode>AD</CCode>

</Country>

<Country>

<CName>ANGOLA</CName>

<CCode>AO</CCode>

</Country>

<Country>

</countryData>

the output will be ,

ID CName CCode

1 AMERICAN SAMOA AS

2 ANDORRA AD

3 ANGOLA AO

Please giveme query .....