Compare two XML data in SQL Server

I was been searching for a solution to compare two XML data in SQL Server, then finally ended up using a great function written by Jacob Sebastian. This function returns 1 if it does not match, and returns 0 in identical case. However this function is been tweaked up little bit in recursion section and does not support typed XML so far.

 

Prasad Sahoo

Prasad Sahoo, is an enthusiast of Microsoft technologies in general and a passionate database professional, mainly focusing on SQL Server performance tuning and business intelligence. He has contributed a long time of his career working on SQL Server and other RDBMS. If he is not busy with SQL stuff then he must be watching some Hollywood movies.

Leave a Reply

%d bloggers like this: