update xml value in xml column sql

Asked May 01 '15 at 12:50

Active May 01 '15 at 12:50

Viewed 35 times

I've got the following snippet of an xml retrieved from an sql column.

<ALT_CODE1>4D000BF1S20</ALT_CODE1>
<ALT_CODE2 />
<SERIAL_NO>1450010010</SERIAL_NO>

I'm trying to update the value of ALT_CODE2. When I use the following code it doesn't update the value of ALT_CODE2. I presume because there isn't a value present. How do I update / insert the value into ALT_CODE2 please:

SET @sqlSTR = '
UPDATE ##t
SET yourxml.modify(''replace value of (/LabelData/ALT_CODE2/text())[1] with ''''' + @Alt_Code2 + ''''''')
WHERE rowId = 1';

EXEC(@sqlSTR)

asked May 01 '15 at 12:50

codingitup

Hi, I did try and look at that but for some reason it deletes all entries and doesn't insert a new one.. – codingitup May 01 '15 at 13:46
1

@codingitup update the question with your latest query – har07 May 01 '15 at 14:03

update xml value in xml column sql

0 Answers0