Wrox Programmer Forums
|
SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 11th, 2008, 09:13 AM
Authorized User
 
Join Date: Aug 2006
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to tusharkale
Default XML update

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







Similar Threads
Thread Thread Starter Forum Replies Last Post
XML update (ntext column) tusharkale SQL Server 2000 11 July 24th, 2008 01:25 PM
how to update a xml file billbillbill XML 2 April 11th, 2007 08:23 AM
Update XML venutm XML 2 March 7th, 2006 11:10 AM
update xml file using vbs thesun99 XML 0 March 21st, 2005 02:32 AM
DataGrid .. XML .. Errors to update sean XML 2 July 10th, 2003 09:16 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.