hemtros
2/2/2017 - 5:01 PM

Update one of the value in Xml column of a table

Update one of the value in Xml column of a table

UpdateDatabaseXMLColumn.sql
content_copyfile_download
UPDATE qf.ReceptionPoint
   SET SessionParameters.modify('
    replace value of (/Parameters/Parameter[@name="TotalPages"]/text())[1]
    with sql:variable("@l_TotalPages")
   ')
  WHERE ReceptionPointId = @ReceptionPointId