Usage of Parser interfaces inside a Store Procedure in SQL Server

Hi All,

I have an XML String which has data in it. I need to pass the string as an input to a Stored Procedure, fetch the data, update the database tables accordingly. But how do i retrieve the data from an XML string from inside a Stored Procedure. Do we need to use the Parser interfaces inside it(Either DOM or SAX) to retrieve the data ? If so, how do we do it. Or do we have any other approach to attain this.

Thanks
Gopi