SQL Server 2008: Modify xml replacing an attribute value with a value of a column - Stack Overflow

update @Table set XmlPart.modify('replace value of (/Group/@count)[1] with sql:column(Cnt)') ... SQL Server 2008 XML replace element values with text from other element values 3 Updating Xml attributes with new values in a SQL Server 2008 table 0 1 1 ...

stackoverflow.com