在SQL Server 2005中使用转换更新XML节点

I have a column that contains XML data, but is TEXT type and not XML type. (I have to leave it like this for another reason).I have a column that contains XML data, but is