February 16, 2016 at 9:37 pm
Comments posted to this topic are about the item Equality on Nullable Columns
February 16, 2016 at 10:42 pm
Good question, thanks.
...
February 16, 2016 at 10:49 pm
This was removed by the editor as SPAM
February 16, 2016 at 11:02 pm
Nice and easy question. Good to see these kind of question.
basics man basic 😉
Thanks for sharing
February 16, 2016 at 11:59 pm
Perhaps it would be worth to mention how the setting of ANSI_NULLS affects the evaluation.
February 17, 2016 at 2:58 am
Incredible that at the time of writing, only 75% got this right!
February 17, 2016 at 5:45 am
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
February 17, 2016 at 2:48 pm
Yeah, easy. Thanks, Mayank, and bring us more! 😉
February 17, 2016 at 11:31 pm
Thanks All 🙂
February 18, 2016 at 7:25 am
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.
February 23, 2016 at 5:17 am
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. 😉
March 9, 2016 at 4:31 pm
Good question, good basic knowledge.
March 10, 2016 at 11:39 am
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