Good question. I was thrown by the 'does not have permission' option, and thought that maybe if the user did not have permission to create tabbles then this is the...

Oleg Netchaev (7/6/2010)

---

select cast('1 234' as int);

will never fly simply because it is not a valid way to represent the number in every locale (though it is valid in some...

Oleg Netchaev (7/6/2010)

---

I think what is happening here is the following: isnumeric('') = 0 and because the trailing spaces are truncated when the strings are compared, i.e. '' = '...

I've just changed my Regional Settings to French, so the thousands seperator is a space. But even now, IsNumeric('1 234') returns 0.

I knew there was a good reason that I...

Maybe if someone posts to the discussion to point out an error in the question, the system could somehow check if there are already 10 posts saying the same thing,...

I've probably been answering too many of these questions recently so always looking for the trick!

A good idea, but a bit too easy to guess! Even though I failed to come up with an example, I got it right as the obvious answer was 'not...

I think it's a good question - designed to make you think a bit and work out that you don't actually need to know anything about database ids in order...

I just used the len(case...) statement - since this can return only one row (master) then the answer is the one with only a single option.

I've seen that one before somewhere.

It becomes slightly more obvious if you add a 'count(*)' to the select list

I agree with Hugo - I knew the modulus answer, but had no idea what the others were. So got it correct as only one option had the right value...

I always do an explicit create - it's more code, but it means...

The answer has to be Yes, because if there was any sort of syntax error that stops it being created, then both the other two answers would be correct, and...

Lots of people seem to be saying that because lots of other QotDs have contained accidental syntax errors, then this one is a BAD QUESTION because it contains an intentional...

Well I learnt something, though probably not what was intended.

Believe it or not, I never realised that identity columns are ignored if you could insert into a table using that...