Compare XML column to XML variable (The XML data type cannot be compared or sorted, except when using the IS NULL operator).‌‌‌‌‌‌‌

SQLServerCentral » Latest topics

Compare XML column to XML variable (The XML data type cannot be compared or sorted, except when using the IS NULL operator).‌‌‌‌‌‌‌

Hello,

I need to compare an XML column with an XML variable. If the values match, we will not process the data, but if the values do not match then we INSERT. Does anyone know a way around this?

      

more info...