aschaffer (3/14/2012)

---

Sorry if I missed it, but a request that when offering a part X of Y series of articles, to please include links to the previous articles in the series...just makes it easier to find. I didn't see part 1 and would like to start there before reading part 2. Thanks.

- to change the n-th element's value where n is not known before hand (i.e. avoid putting some constant like [1] in the xpath),

declare @xml xml='<root><element>1</element><element>2</element></root>'
declare @n int=2
SET @xml.modify('replace value of (//root/element[position()=sql:variable("@n")]/text())[1] with "12"')
select @xml