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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-06 : 08:49:38
|
| Deepa writes "Hi,I would like to post the following question.The scenario is that i should update more than one record in a single table using a stored procedure to which i will send a xml string , say ,'<abc> <tabname field1="value1" field2="value2"..../><tabname field12="value12" field12="value12"..../><tabname field13="value13" field12="value13"..../>...</abc>'..How can this be achieved using SP_XML_PREPAREDOCUMENT??Am Using MS SQL server 2000 and Windows 2000.Thanks in advance!!" |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-08-06 : 11:18:47
|
| Just use it the same as you would any tableupdate t1set t1.col2=t2.col2from mysqltable t1join(select col,col2 from OPENXML(.....)) t2on t1.col1=t2.col1HTHJasper Smith |
 |
|
|
|
|
|
To update multiple records using SP_XML_PREPAREDOCUMENT