Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Reading xml datatype elements from sql server 2005

Author  Topic 

subhaoviya
Posting Yak Master

135 Posts

Posted - 2010-10-20 : 04:35:25
Hi,
I am having xmldatatype column c1 in table t1 having the value like

<a1 a1a='1' a1b='hai'>
<b1 b1a='g' b2b='e'>
<c1 b1a='g' b2b='e'>
</a1>

i need to copy this <b1 b1a='g' b2b='e'> element to another table t2 having column col1.

how to do this, please help to do this out

thanks
subha
   

- Advertisement -