Posted by CK on 11/27/06 21:43

I tried it and I get the same error. Any other ideas?
*****I just tried this and it works great!!!

UPDATE Sales.DeliverySchedule
SET DeliveryList.modify('declare default element namespace
http://schemas.adventure-works.com/DeliverySchedule;
replace value of (DeliveryList/Delivery/Address[1])[1] with "7194 Fourth
St., Rockhampton"')
WHERE ScheduleID = 1

<markc600@hotmail.com> wrote in message
news:1164662865.592811.99820@j44g2000cwa.googlegroups.com...
>
> Try this
>
>
>
> UPDATE Sales.DeliverySchedule
> SET DeliveryList.modify('declare default element namespace
> "http://schemas.adventure-works.com/DeliverySchedule";
> replace value of (DeliveryList/Delivery/Address[1]/text())[1] with
> "7194 Fourth St., Rockhampton"')
> WHERE Sales.DeliverySchedule.ScheduleID = 1
>

• Next in forum: Re: Default "Auto Close" to no for entire server?
• Prev in forum: Re: Update Query using XQuery
• Thread view: Re: Update Query using XQuery

[Reply to this message]