xml & modify() method!

Question

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 1

Hi

Please either mask your xml < and > or attach an example file.

Greets

Flo

VM-723206 SSCrazy Points: 2964 More actions · Answer 2

Sorry, missed it!

Why does the below code not replace the value with 100? Not sure what I'm doing wrong. The value still remains 50 after modify().

declare @xml xml

select @xml = '

'

set @xml.modify('replace value of (/Test/@value)[1] with "100"')

select @xml

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 3

Hi

Maybe just attach a text file with your sample.

Greets

Flo

VM-723206 SSCrazy Points: 2964 More actions · Answer 4

SSCrazy

Points: 2964

March 24, 2009 at 9:07 am

Aah, here's what's to be substituted into @xml.

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 5

VM (3/24/2009)
Aah, here's what's to be substituted into @xml.

Perfect!

Try this:

declare @xml xml

select @xml = '<Test>

<value>50</value>

</Test>'

set @xml.modify('replace value of (/Test/value/text())[1] with "100"')

select @xml

Greets

Flo

VM-723206 SSCrazy Points: 2964 More actions · Answer 6

SSCrazy

Points: 2964

March 27, 2009 at 11:09 am

Thanks Flo! Perfect!

Cookies on SQLServerCentral