Code snippet for updating specific data in xml column in mssql
declare @date datetime set @date = GETDATE() UPDATE XmlDocuments SET xmlmetadata.modify ('replace value of (/Header/Date/text())[1] with sql:variable("@date")') WHERE ID = '1000001'
No comments:
Post a Comment