Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > Indigo

Vista - 2005 xml equality

 
 
Old 07-10-2007   #1 (permalink)
Marc Gravell


 
 

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


Similar Threads
Thread Forum
COM equality testing VB Script
Is there any compatibility issue between 2005 R2 and 2005 R2 SP1 f Virtual Server
Difference between VS 2005 and VS 2005 Express .NET General
Installing Visual Studio 2005 Std Ed, SQL Server 2005 Expr./Compac Vista installation & setup


Vista Forums 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 Ltd

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