retrive all child node in sqlserver 2005

Question

Hi,

Have a xml file data as below

<TEST<ARGS><ARG>500</ARG><ARG>BSB</ARG><ARG>SO:99</ARG><ARG>20</ARG></ARGS></TEST>

Want to retrieve ARG values and store into a database table. Is anyone help me how to write a store procedure for this.

Thanks in advance

Answer 1

You won't be getting a reply here as this is a **Search Server ....** forum not SQL Server !

Try again to look for an SQL Server forum.

---

WSS FAQ sites: http://wssv2faq.mindsharp.com and http://wssv3faq.mindsharp.com
Total list of WSS 3.0 / MOSS 2007 Books (including foreign language) http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/V%20Books.aspx