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 |
|
portrman
Starting Member
24 Posts |
 Posted - 2007-01-23 : 21:37:11
|
| I have a table with a column called data. In that column is a value like:<settings><myVarOne>valueOne</myVarOne><myVarTwo>valueTwo</myVarTwo></settings>All I'd like to do, is update all the myVarOne values. So the new value for data would be:<settings><myVarOne>newValueHere</myVarOne><myVarTwo>valueTwo</myVarTwo></settings>This will likely be SQL2000 not SQL2005 but it would be useful to know for both.I've looked at OPENXML but all the examples seem keen on using sp_xml_preparedocument and then OPENXML needs the @idoc so I'm thinking there is something else.If someone can point me in the right direction that would be extremely helpful as I haven't found anything that makes sense to me. UpdateGrams seems very overblown for manipulation like this when OPENXML is sooo very close to being correct.Thanks!Chad |
|
|
portrman
Starting Member
24 Posts |
Posted - 2007-01-25 : 20:35:09
|
| Replying to myself ... does anyone have any direction they can give me? I've kept trying but haven't got anywhere.Thanks |
 |
|
|
|
|
|
Update XML in a column