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 2008 Forums
 Transact-SQL (2008)
 Function to compare 2 xml file to get differences

Author  Topic 

micnie_2020
Posting Yak Master

232 Posts

Posted - 2013-03-21 : 03:38:27
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

52326 Posts

Posted - 2013-03-21 : 04:23:41
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
   

- Advertisement -