This is the data that i generated using the command SELECT * FROM abc.ccc.BR_MTR_IMPORT FOR XML AUTO
<abc.ccc.BR_MTR_IMPORT MTR_KEY="xxx-xxx-xxxx" TRAN_DATE="2010-06-06T12:00:00" VERSION="2" FILE_ID="1660" ROW_STATE="2.75" PROCESS_STATE="1.34" LST_MODIFIED_DT="2010-06-11T16:40:18.553" LST_MODIFIED_USER="qwer" /> </br>
<abc.ccc.BR_MTR_IMPORT MTR_KEY="zzz-zzz-zzzz" TRAN_DATE="2010-06-06T12:00:00" VERSION="3" FILE_ID="1660" ROW_STATE="2.75" PROCESS_STATE="1.34" LST_MODIFIED_DT="2010-06-11T16:43:19.360" LST_MODIFIED_USER="qwer" /></br>
<abc.ccc.BR_MTR_IMPORT MTR_KEY="nnn-nnn-nnnn" TRAN_DATE="2010-06-06T12:00:00" VERSION="4" FILE_ID="1660" ROW_STATE="2.75" PROCESS_STATE="1.34" LST_MODIFIED_DT="2010-06-11T16:46:20.217" LST_MODIFIED_USER="qwer" /> </br>
<abc.ccc.BR_MTR_IMPORT MTR_KEY="hhh-hhh-hhhh" TRAN_DATE="2010-06-06T12:00:00" VERSION="5" FILE_ID="1660" ROW_STATE="2.75" PROCESS_STATE="1.34" LST_MODIFIED_DT="2010-06-11T16:52:20.973" LST_MODIFIED_USER="qwer" />
<abc.ccc.BR_MTR_IMPORT MTR_KEY="fff-fff-ffff" TRAN_DATE="2010-06-06T12:00:00" VERSION="1" FILE_ID="1660" ROW_STATE="2.75" PROCESS_STATE="1.34" LST_MODIFIED_DT="2010-06-11T16:37:17.450" LST_MODIFIED_USER="qwer" />
*/
presented above is the result i got from the database.
What i want to know is... is there a way that, if we do any change to the data in the xml document, and can it be inserted back into the database table? if so how.
To be more clear, if in this xml document if i change the file ID number to 1545.. can it be done through this XML and can i push it back through this XML document.