And why would you not use the Script() method, given that it exists?

And this is why you should ALWAYS use two-part column names, preferably with well chosen table aliases.

Ok. Guess I need to understand the difference between a localized version and a language version. Or not; sounds more like asking for trouble than anything else...

From the referenced article:

Not quite sure how this tallies with the purportedly...

Tsk, tsk...

I got it right. Collations are tricky business. I think this is one case where people from countries that don't use English as their primary language have an edge.

Interesting. If you look in the linked documentation, you're led to believe that the ... FILE = NUL syntax (without the single quotes) is the correct one, but clearly that...

One has to admire Steve's tenacity at getting questions slightly bent.:hehe:

Very hard to know if 'Adult' refers to the Age or Genre for the movie "'s a wonderful life"...

Interesting question, but I would argue that R isn't "smart enough to know that the last parameter, unnamed, is second", but  rather that R is "stupid enough to not complain...

Not sure I follow the reasoning behind the correct answers. WITH CUBE returns more rows, but not WITH ROLLUP. And yet they return the same number of rows? How is...