SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Function to compare 2 xml file to get differences
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

micnie_2020
Posting Yak Master

Malaysia
226 Posts

Posted - 03/21/2013 :  03:38:27  Show Profile  Reply with Quote
Hi All,

Anyone have sql function to compare 2 xml file & get the difference as below:-

1. ID - Deleted Record
2. ID - New Inserted Record
3. ID - Record had been modified


Something like this i am looking for:-
Select * from dbo.Compare('C:\a.xml', 'C:\b.xml')

Please Advise.

Thank you.

Regards,
Micheale

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 03/21/2013 :  04:23:41  Show Profile  Reply with Quote
are the xml schema same for both the documents?

Anyways see

http://beyondrelational.com/modules/2/blogs/28/posts/10317/xquery-lab-36-writing-a-tsql-function-to-compare-two-xml-values-part-2.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000