Equality on Nullable Columns
-
Comments posted to this topic are about the item Equality on Nullable Columns
-
Good question, thanks.
...
-
This was removed by the editor as SPAM
-
Nice and easy question. Good to see these kind of question.
basics man basic
Thanks for sharing
-
Perhaps it would be worth to mention how the setting of ANSI_NULLS affects the evaluation.
-
Incredible that at the time of writing, only 75% got this right!
-
Thank you for your useful question and good explanation. A similar instructive example
is shown in this ref: https://msdn.microsoft.com/en-us/library/ms188048.aspx
-
Yeah, easy. Thanks, Mayank, and bring us more!
-
Thanks All
-
Toreador (2/17/2016)
Incredible that at the time of writing, only 75% got this right!Yeah, well I read it a bit too quickly, and couldn't quite accept the idea of a nullable ID column, so I just assumed the insert would fail.
Just because you're right doesn't mean everybody else is wrong. -
Rune Bivrin (2/18/2016)
Toreador (2/17/2016)
Incredible that at the time of writing, only 75% got this right!Yeah, well I read it a bit too quickly, and couldn't quite accept the idea of a nullable ID column, so I just assumed the insert would fail.
I know what you mean, but the table definition was clear. I admit I took another look at it.
-
Good question, good basic knowledge.
-
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply