I don't not fail to disagree that your statement is wrong

I would have expected 'NULL' to be treated as a string with that...

This ^^^

It probably will always return 2 given the...

The others I understand, but not this one!

Incredible that at the time of writing, only 75% got this right!

It might be skipped by the SQL engine, I don't know. But logically it's not. It's applied, the outcome...

Ed Wagner (1/25/2016)[/b]

---

Interesting. I half-expected this to be covered in Books Online, but it isn't. My guess is that it's because NULL is unknown. If you wanted...

Again, a good idea, but the choices available meant I only had to think about the first two before I got a unique option.

samot-dwarf (1/14/2016)

---

I doubt, that your real solution (specifying an explicit collation string at each char field) is really a real solution, because it is very error prone - you have...

Rich Mechaber (1/6/2016)

---

This, for example, throws an error:

SET LANGUAGE british

SELECT CAST('2003-02-28' AS datetime);

Server: Msg 242, Level 16, State 3, Line 4

The conversion of a char data type to a datetime...

Especially to the experienced - the inexperienced are more likely to check things afterwards

I'm astonished that nobody has mentioned this yet, but option 4 will fail as there is no such column.

Perhaps everyone is using the discussion to learn and share information, rather...

Typo alert!

Option 4 "I can include deterministic computed columns. "

Explanation of why this is wrong "The computed columns that are deterministic can be included."

Oops :blush:

julienchappel 38298 (12/13/2015)

---

SOME CONSISTECY of which you are so committed would be nice if you follow yourself as well. It is really frustrating the reading one version of a code...

Well I guessed right, but the correct answer is surely that ID is not a valid data type for myID.