SQL 2005 xQuery how to compare complete xml document to xml data type column

• Kinch Reindl

  Grasshopper

  Points: 16

  More actions

  July 25, 2006 at 1:05 pm

  #191580

  SQL 2005 xQuery how to compare complete xml document to xml data type column

  I'm hoping this is so simple that none of the MS articles included it.  I'd like to use C# to execute an xQuery which will compare an xml document to the xml documents stored in an xml data type column.  I've got lots of good examples (.exist, .value, .query) to find records based on certain parts of the xml matching but I'm holding out for a really simple example which will compare the complete document in the where clause. 

  I wish I didn't need to compare the entire document but my marching orders are to do that.  I've tried passing in an entire string of the xml for comparison without much luck and I'm hoping that isn't the answer.

  Thanks in advance for any suggestions!

   Kinch

• Kinch Reindl

  Grasshopper

  Points: 16

  More actions

  August 11, 2006 at 9:44 am

  #654603

  It looks like I can use the xpath 2.0 function deep-equal to compare

  deep-equal(a,b)

  I hope this works well since generating a where clause from xml isn't the cleanest.