Raghavendra Mudugal (9/5/2012) L' Eomot Inversé (9/5/2012)
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 :-P )
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.
This question (the second, chronologically) basically asked which of the insert formats used would fail and which would work.
The other question (the first, chronologically) used these insert formats to set up sample data and than asked what the effect of a certain statement on that sample data would be. That question is completely different. The sample data could have been given in a variety of other formats without affecting the question.
So yes, they are different questions. And I think they are both good by themselves. But in combination and in the order they are published here, this (second) question is weak: the same methods of inserting were used for the first question and the rest of that question implied that they would run error-free, so anyone who looked more than casually at that question is bound to get this one right. Had the order been reversed, then both questions would have been good.
Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis