How to edit/update xml column using XQuery

ALTER PROCEDURE [UpdateUnitsLocations]
   @varUnitId [uniqueidentifier],
   @varLat [varchar](100),
   @varLng [varchar](100)
AS
BEGIN
   SET NOCOUNT ON;

   UPDATE [UnitsLocations]
   SET LocationXML.modify(' insert <point lat="{sql:variable("@varLat")}" lng="{sql:variable("@varLng")}" /> as last into (/markers/line)[1] ')
   WHERE UnitId = @varUnitId
END

Advertisement

Tags: sql server, stored procedure