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
Advertisements

About Saad Khan

Saad is an ASP.NET developer with 4 years of experience, and has also made a number of contributions to the Sitefinity marketplace and community. He loves to explore new code, and create innovative tools and procedures while exploring new approaches in his work with Sitefinity and MVC. As an experienced .NET developer, he frequents both Telerik and Microsoft technologies. In his spare time, Saad is an avid gamer and movie fanatic, and also experiments with new and interesting tools on the Microsoft platform.​​

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: