Maybe that B *really* stands for "Bayer" 😉

😀

In general, I would agree that testing for equality often makes for more easily readable code, but there are always exceptions...

good question.

Why is it "always a better practice to be checking for equality in conditions rather than inequality"?

I would have thought that this rather depends on the check you're interested...

Thanks for the good tip (reminder?) about ANSI NULL

Once again, the given "answer" does not always work if youre not running in English Language...

For example, in Dutch, month 5 (mei) would NOT be included and month 6 (juni)...

I trust you all realise I was talking tongue-in-cheek there!;)

come on, Derek. 😉

Why would you try running a query about system objects in a database other than master?

...but the command as given throws up a syntax error because the comma isn't there...

Sure, I was lazy and didn't check the syntax, and I'm not going to bitch about...

sorry - I obviously missed that all-important comma in the question (and in the given "correct" answer) 😉

Maybe the question should have had the "on all SQL versions except EXPRESS" in there...

If you call xp_servicecontrol on EXPRESS edition and get an error, that is NOT telling you...

See also

http://msdn2.microsoft.com/en-us/library/aa178423.aspx

(has some nice pretty pictures) 😀

I was reading the same article, and inferred from the fact that it "is available to CLR clients as the SqlHierarchyId data type" that the CLR data type was in...

silly me!

You're right - I had just looked at the total values, but I see it now... :blush:

(current values)

95% of people chose for 64-bit

34% chose for 32-bit

Only 29% chose *both*

😎

On the top right of the screenn when you've answered the question you get the little graphs, with numbers by them, right?

Well - For me - something just doesn't compute...

I agree that the question was not perfectly worded.

The question I think should have read

"In THIS EXAMPLE OF the new ..."

I did select the correct answer, but basically it was...