honza.mf (5/21/2010)

---

It can be some error during copy-paste. I had no problem. Where have you copied the XML segment from?

Bad thing in these forums is, HTML washes all XML/HTML details...

honza.mf (5/21/2010)

---

If you are using Notepad as your text editor, try to use Save As and check file encoding. XMLs work fine with UTF-8. If you have xml declaration, encodings...

Hugo Kornelis (5/21/2010)

---

How did you try to open the file? I followed these steps:

- Run code with output to text mode

- Select output, right-click, Copy

- On desktop: right-click, New, Text...

Nope, doesn't work for me,...

Am I the only one who gets an error trying to display it in IE? Version 8.0.6001.18702

Actually on trying it again my...

I guessed right, but the answer is wrong!

I ran the script and got an error

Error Character '', hexadecimal value 0x0 is illegal in XML documents.

ie the first option, which is...

Interesting - it never occurred to me that the identity values wouldn't be available in the inserted table!

So how would you get the identity values of the rows you'd just...

Hugo Kornelis (5/7/2010)

---

If you define the identity column as a PRIMARY KEY, then there always is an index. SQL Server automaticallly creates an index when you create a PRIMARY KEY...

If you never use the identity column in queries but only use it as a primary key then doesn't it actually make performance...

Easy? Only if you google the results.

All the QOTDs...

I'd just like to make clear that although I was (I think) the first person to comment on the answer to the second part, I was reflecting negatively on myself,...

"SQL Server does not have an efficient way to retrieve rows based on a known value for PersonID."

There have obviously been too many trick questions lately, as I thought this...

I'm lost for words!

Good - I won't worry too much that I got the answer wrong 😉