About the value values in the Replace XML file in the database (SQL Server)

DECLARE @xmlDoc XML
declare @PrintValue nvarchar (max)

Select@xmlDoc =description fromDbo. Wf_persist_descriptorwhere[process_id]='1e9e9059-50ea-adac-4660-918cd54e3436'--the data in the data is read out, the database error is nvarchar (max) here can be directly converted

Set@xmlDoc. Modify ('Replace value of (/process/activities/activity[@key = "N8"]/name/text ()) [1] with "Gome Online coo"')--Replace the value below a node. Text () is the text value of the Read node store

UPDATE dbo. Wf_persist_descriptorSetDescription=convert (nvarchar (max), @xmldoc)where[process_id]='1e9e9059-50ea-adac-4660-918cd54e3436'
Set@[email protected] ('(/process/activities/activity[@key = "N8"]/name) [1]','nvarchar (MAX)')
Print @PrintValue

About the value values in the Replace XML file in the database (SQL Server)