DECLARE @xml xml SET @xml = (SELECT TOP 1 ConfigXML FROM VIPRE.sbc.ConfigC) SET @xml.modify('replace value of (/CounterSpyConfig/ServiceHttpPort/text())[1] with "19082"') UPDATE VIPRE.sbc.ConfigC SET ConfigXML = @xml SELECT TOP 1 ConfigXML FROM VIPRE.sbc.ConfigC