Windows Vista Forums
Vista Forums Home Join Vista Forums Donate Vista Tutorials Tags

Welcome to Vista Forums we are your forum to discuss Windows Vista x64 and x86 systems. Whether you need help or just want to post an idea you have on Vista, this is the forum for you.
Register at Vista forums...the world biggest Windows Vista resource Join Vista Forums Now

Go Back   Vista Forums > Microsoft Technical Newsgroups > Indigo

2005 xml equality

Update your Vista Drivers Update Your Drivers Now!!
 
 
Thread Tools Display Modes
Old 07-10-2007   #1 (permalink)
Marc Gravell
Guest


 

2005 xml equality

Is there any (perhaps roundabout) mechanism for testing xml columns
for equality?

Specifically, as part of a bulk update (i.e. into a staging table that
is then migrated) I want to short-circuit any records whose xml hasn't
actually changed, since I have audit requirements and I don't want to
fill in the audit every time a record is present in an extract - only
when it has actually changed.

Any ideas? I have tried a few approaches like extracting as ntext or
some of the checksum functions, but not with any success. CLR perhaps?

Marc



My System SpecsSystem Spec
 

Thread Tools
Display Modes



Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there any compatibility issue between 2005 R2 and 2005 R2 SP1 f Peter Virtual Server 1 07-21-2008 07:55 PM
Difference between VS 2005 and VS 2005 Express Curious .NET General 4 03-09-2008 02:20 PM
LCS 2005 SE Armageddon Live Messenger 0 12-20-2007 11:29 AM
Installing Visual Studio 2005 Std Ed, SQL Server 2005 Expr./Compac Stéphane Vista installation & setup 4 04-28-2007 11:20 AM


Vistax64.com is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media 2005-2008

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51