<div>
i found my answer before this post so i didn't try this i am using xml.modify. thanks
</div>


i found my answer before this post so i didn't try this i am using xml.modify. thanks

<div>
<div class="content wysiwyg-content">
say i have a table that has 2 column 1 is id and other is xml data<br />
<br />
i inserted <br />
1, xml&lt;test&gt;&lt;q1&gt;&lt;/q1&gt;&lt;/test&gt;<br />
<br />
now i inserted <br />
2, xml&lt;test&gt;&lt;q1&gt;&lt;/q1&gt;&lt;q2&gt;&lt;/q2<wbr />&gt;&lt;/test&gt;<br />
<br />
how do i detect to say 2 and 1 are really the same let me just add q2 into row 1 and delete row 2 using xml modify
</div>
</div>


say i have a table that has 2 column 1 is id and other is xml data

i inserted 
1, xml<test><q1></q1></test>

now i inserted 
2, xml<test><q1></q1><q2></q2></test>

how do i detect to say 2 and 1 are really the same let me just add q2 into row 1 and delete row 2 using xml modify

xml modify sql 2008

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.