I always take surveys like this with a sizeable helping of salt. People in general are not good at self-assessment (see for example http://en.wikipedia.org/wiki/Illusory_superiority).

I'd guess that if 60% of people...

Therefore some of us have not.

In the interest of sating my (perhaps irrational)...

Hugo, I do hope that you've posted the same excellent analysis as a comment to the Microsoft documentation... 😛

da-zero (11/23/2010)

---

I like the point the question tried to make, namely using the GO statement as an instrument to loop, but I do not like the trickery with the #...

Carlo Romagnano (11/22/2010)

---

Carlo Romagnano (11/22/2010)

---

WayneS (11/22/2010)

---

BTW, the best way to check for the existance of a temporary table in your current session is:

IF OBJECT_ID('tempdb..#YourTempTable') IS NOT NULL

Note that in SQL...

jts_2003 (11/16/2010)

---

A good introductory article, but I think people need to be careful when looking into using Indexed Views.

I recently added a view to a 3rd party application and thought...

Samuel Vella (11/10/2010)

---

fszendzielarz (11/10/2010)

---

Oh yes. I forgot about that.

Doesn't it seem ridiculous that functionality that is already implemented is disabled for those who cannot pay for it? The irony...

Of course, if you're storing your value in an attribute, NULL is represented by the absence of the attribute in the record element, and SQLXML deals with that fine.

Except for...

Good question. It would have been more difficult if there had been an option for 1-Boston;2-New Delhi

It generally does. 😀

jlennartz (9/27/2010)

---

The discussion usually answer my questions but not this time. Doesn't "isnumeric(char(32)) as n" return 0? And if so wouldn't "select sum(n) from l" also...

Thanks for the good discussion. For the record, I agree with Hugo -- ISNUMERIC doesn't give you very good information because it's test is overly broad.

For example,

\- ...

Yes. This technique is called a recursive CTE. It's a...

Hugo Kornelis (9/24/2010)

---

tommyh (9/23/2010)

---

Have to agree with UMG Developer. The "Multiple identifier columns" shouldnt be part of the answer for 2 reasons.

1. Its not part of MS recommendations (atleast not...

Dave62 (9/22/2010)

---

sknox (9/22/2010)

---

... --other data changes (e.g, by other users) are not rolled back. In this case, the items related to a backup are the backup file itself, and the...