Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2009-06-16 : 11:09:34
|
| Hello All,I have a table name “TestData” that has a xml data field name “Measure_Detail” which I want to update its content. A sample of the xml text is below. What I want is to update BatchID = @BatchID<Measure_Detail><Detail_Date>2009-06-13T05:41:36.543</Detail_Date><BatchId>9CDF34D8-7F1D-43BF-93C7-B4F715ACE449</BatchId><DSIO_ENT_ID>1600025168</DSIO_ENT_ID><LAST_NAME>Wilson</LAST_NAME><EMS_ENT_TYPE>PER</EMS_ENT_TYPE><Vendor_Type>EXPERT_WITNESS</Vendor_Type><ENT_TABLE_ID>194</ENT_TABLE_ID><DTTM_RCD_ADDED>19860826160731</DTTM_RCD_ADDED><ADDED_BY_USER>atdisuj</ADDED_BY_USER><DTTM_RCD_LAST_UPD>19990613170150</DTTM_RCD_LAST_UPD><UPDATED_BY_USER>atdisuj</UPDATED_BY_USER></Measure_Detail><Measure_Detail><Detail_Date>2009-06-13T05:41:36.543</Detail_Date><BatchId>A8A5843D-48DC-4C79-89FD-BB1DBE2C64A1</BatchId><DSIO_ENT_ID>1600025421</DSIO_ENT_ID><LAST_NAME>Smith</LAST_NAME><EMS_ENT_TYPE>PER</EMS_ENT_TYPE><Vendor_Type>EXPERT_WITNESS</Vendor_Type><ENT_TABLE_ID>194</ENT_TABLE_ID><DTTM_RCD_ADDED>19810826160812</DTTM_RCD_ADDED><ADDED_BY_USER>hscfms</ADDED_BY_USER><DTTM_RCD_LAST_UPD>19810826160812</DTTM_RCD_LAST_UPD><UPDATED_BY_USER>hscfms</UPDATED_BY_USER></Measure_Detail>Please advice. Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-16 : 13:09:39
|
| see thishttp://technet.microsoft.com/en-us/library/ms345122.aspx |
 |
|
|
|
|
|
How to update a field in a XML field