|
Posted by markc600 on 11/27/06 21:27
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
Navigation:
[Reply to this message]
|