Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  Update more than one node in single xml document

Author  Topic  tejal Starting Member 1 Post Posted - 2008-02-05 : 07:13:43 hi all I have used a XML datatype in SQL server 2005 database to store the XML data. I want to update the multiple nodes in XML coulumn at same time. How can i achieve this?? Example: Here is the XML in which i want to updatet the multiple nodes... <Search> <title>Search</title> <ip>127.0.0.1<ip> <searchEngine enable="1">google</searchEngine> </Search> I want update the title,ip and searchEngine at the same time in one go... And if it is not possible to update multiple nodes in XML column at same time that what is best possible solution to achieve this? many thanks