XQuery .modify syntax help

• TT-131210

  SSCommitted

  Points: 1603

  More actions

  January 21, 2011 at 5:26 pm

  #245728

  I need to update the File1 Value field but I not sure how to do the syntax.

  DECLARE @XmlData xml

  SET @XmlData =

  '<ParameterValues>

  <ParameterValue>

  <Name>File1</Name>

  <Value>MyFile1.txt</Value>

  </ParameterValue>

  <ParameterValue>

  <Name>File2</Name>

  <Value>MyFile2.txt</Value>

  </ParameterValue>

  </ParameterValues>'

  DECLARE @NewValue varchar(50)

  SET @NewValue = 'MyFileNew.txt'

  SELECT @XmlData.query('/ParameterValues/ParameterValue[Name="File1"]/Value[1]/text()')

  SELECT @XmlData.modify('replace value of (/ParameterValues/ParameterValue[Name="File1"]/Value[1]/text())[1] with sql:variable("@NewValue")')

  SELECT @XmlData

  Any help would be appreciated

  Tim

• SwePeso

  SSC-Dedicated

  Points: 39757

  More actions

  January 23, 2011 at 1:10 pm

  #1276998

  Change

  SELECT @XmlData.modify

  to

  SET @XmlData.modify

  ---

  N 56°04'39.16"
  E 12°55'05.25"

• TT-131210

  SSCommitted

  Points: 1603

  More actions

  January 23, 2011 at 9:02 pm

  #1277032

  and I thought the XPATH stuff was the hard part

  Thanks

  Tim