I have table with two columns. ID (int) (primary key) and Docs (ntext)..which has xml stored in this columns.
I have around 3lakhs records.I have to update few nodes in xml in most efficient and fastest way.

Is there any way to do this? I have tried thrugh .net fetching the xmls n then serializing/deserializing them n then updating particular node. But it is taking time.

I am using SQL server 2005 database. Converting this column to XML type would require lot of code changes to my entire project.


please suggest me the way thru this.

Thanks