xml modify 'replace value of' using sql:variable

xml modify 'replace value of' using sql:variable

瀏覽:395
日期:2025-06-08
In the last "replace value of" sql:variable() is not within XML constuction context so "{...}" shouldn't be used. Try: set @xml.modify('replace value of (/root/item/@value)[1] with sql:variable("@value")') Best regards, Eugene---This posting is provided "...看更多