sql server xml replace or delete

Question

With the table below...what would the replace (or delete/insert) look like if I wanted to completely replace the contents of the xml column with something else...there would no similar nodes in common however I need the PK i to stay intact

CREATE TABLE T (i int, x xml)
go
INSERT INTO T VALUES(1,'<Root>
<ProductDescription ProductID="1" ProductName="Road Bike">
<Features>
 <Warranty>1 year parts and labor</Warranty>enter code here
 <Maintenance>3 year parts and labor extended maintenance is available</Maintenance>
</Features>
</ProductDescription>
/Root>')

score 0 · Answer 1 · answered Jul 16 '13 at 20:00

0

update t
set x='<Root>
<ProductDescription ProductID="1" ProductName="Road Bike v2">
<Features>
<Warranty>1 year parts and labor</Warranty>enter code here
<Maintenance>3 year parts and labor extended maintenance is available</Maintenance>
</Features>
</ProductDescription>
/Root>'
where i=1

answered Jul 16 '13 at 20:00

Chris Allen

605
3
4

Yea you can't update an XML Data Type like that...did you try your answer before posting? – Bayrat Jul 16 '13 at 20:50

sql server xml replace or delete

1 Answers1