Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
Get XML difference
March 15, 2011
i am having two columns whose data type is xml in sql server 2005, i need to compare this two xml columns and get the xml difference in query, i do not want to process it on UI how it can be achived...thanks in advance
Posted Date: March 16, 2011 Points: 20
Retrieve the values from both the columns and store them in string variable. Once done with this you can use the solution in the below link to find the difference between two strings.
Hope this helps.
To post reply
Related Questions Related Questions
difference between an EXE and a DLL
Difference Between console application and windows application?
Difference between Web Garden and Web Farm
Difference Between Response.Write and Response.Output.Write?
Difference between Language and package
Difference between JDK and SDK
Difference Between SDK and IDE
What is the difference between Get and Post method?
What's the difference between Response.Write() andResponse.Output.Write()?
Difference between Factory, Abstract Factory and Inheritance
Latest Forum Questions From The Same Category
Help to get SQL output
how to restore my sql database from my hosting provider?
SQL query to update date range
Add allowance to employee table is wrong or true according to my case
how to remove trailing zeroes in a decimal in sql server
Required Union All Result in two different column
Sql Multiple table data retrival
Table Translation records
How select huge Data from sql without take long time?
Passing using parameter in store procedure get the top3 record from the table
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend