You can do something like this:
UPDATE
dbo.profiles
SET
ProfileXML.modify('replace value of (/ProblemProfile/GroupID/text())[1] with "0"')
WHERE
id = 23
Check out this article on SQL Server 2005 XQuery and XML-DML for more details on what you can do with the .modify
keyword (insert, delete, replace etc.).
Marc
PS: In order to get the value, it would be a lot easier to do just this:
SELECT ProfileXML.value('(/ProblemProfile/GroupID)[1]', 'int') as ID
FROM dbo.profiles
WHERE id = 23
(unless of course you need the XML as a SQL variable for something else later on)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With