How can that question be answered the way it is stated? I've known how NULLS work for ever and still got it wrong. I'm 100% confident in how NULLS work.
Myid = NULL
Myid != NULL
Will both evaluate FALSE, or not give results. If I received results would that be TRUE. By not getting results is FALSE!!!
I think the Question and Answer are phrased badly and incorrect. The answer should be FALSE. How can UNKNOWN be the answer, when I know what the results would be (FALSE).
Maybe, it's only UNKNOWN to the writer. Because, I know it's FALSE. It'll always return NO ROWS, that's pretty well KNOWN.
If you get the question right, it's obvious what UNKNOWN is. How NULLS work!!!
If you got the question right. Here's how NULLS work.
Myid IS NULL (is the proper way to write the statement)
Also, I agree with Jeff Gray on the ANSI NULLS setting.
Please give me my points back!