L' Eomot Inversé (9/5/2012)
Nice question.Raghavendra Mudugal (9/5/2012)
same as this http://www.sqlservercentral.com/Forums/FindPost1351393.aspx with little details change. Got a impression at first that this question was repeated before and then I had to compare between these two 😛 )Well, not really "same", it's a very diffefrent question.
Not sure what I am missing here, but the both questions has the same table structure and then same data to inserts, in the end the previous question uses the SELECT INTO where the data is been copied to the new table and objective of the question completely relays on the table2. Here in this question it is just the first part of the previous question, where the new table creation is been avoided and then the objective of the question here mainly focuses on the XML column set which again can be seen working properly with no errors in the previous one.
I am not sure how it can be very different.
thank you for your reply.
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.