What if null if null is null null null is null?

re: What if null if null is null null null is null?

Denis Gobo — Mon, 01 Oct 2007 16:30:03 GMT

Hugo,

interesting title, take a look at

http://en.wikipedia.org/wiki/Buffalo_buffalo_Buffalo_buffalo_buffalo_buffalo_Buffalo_buffalo

re: What if null if null is null null null is null?

Alejandro Mesa — Mon, 01 Oct 2007 19:25:12 GMT

Hi Hugo,

I really liked the whole serie.

The final question reminded me about a NULL Puzzle, posted by Steve Kass on Jan 2003. I still use it to show others the implication of using "SET ANSI_NULLS OFF". It good that Microsoft is deprecating it.

http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/4693f68a7140bb80/daca91a7912bdc76?q=steve+kass+and+null+puzzle&rnum=2&hl=en

Cheers,

AMB

re: What if null if null is null null null is null?

Hugo Kornelis — Mon, 01 Oct 2007 20:51:46 GMT

It's great to hear that you enjoyed the serie, Alejandro.

I really had to convince myself to write the final two parts, since my mind was already busy preparing psots on much more interesting subjects (no I won't tell - just wait and see <g>), so it's good to hear that I did not do that in vain!

And thanks for the link to Steve's puzzle. I'd seen it before, but had forgotten about it. There's some *REALLY* weird stuff going on with ANSI_NULLS OFF indeed!!

re: What if null if null is null null null is null?

James Luetkehoelter — Tue, 02 Oct 2007 15:20:43 GMT

I really like this post - I hope everyone reading it appreciates how complicated NULL can actually be when implemented correctly. Imagine what happens when someone literally types in the word 'Null' when they mean NULL....sigh...

re: What if null if null is null null null is null?

ScottPletcher — Wed, 03 Oct 2007 14:27:39 GMT

Another great article. I'm glad you were willing to finish writing the series. NULL is tricky enough that more info is always needed.

The Sad State Of Programmers Part 2 : The In Person Interview

Denis Gobo — Mon, 10 Dec 2007 20:02:13 GMT

This is part two of a three part series. Part one was about the phone interview , this part is about

re: What if null if null is null null null is null?

Rajni Padhiyar — Thu, 13 Aug 2009 06:32:09 GMT

Thanks Friend,

Nice article

Regards,

Rajni Padhiyar

Software Engineer

Techsture Technologies

re: What if null if null is null null null is null?

Yogesh Chandra Upreti — Wed, 23 May 2012 05:17:43 GMT

Thanks for this information described in such a nice way.

Thanks a lot.

Regards,

Yogesh Chandra Upreti

Sr. Associate Technology

Magnon Solutions, Noida

re: What if null if null is null null null is null?

Goutam — Mon, 02 Jul 2012 10:53:42 GMT

Thanks for the article, its really great.

re: What if null if null is null null null is null?

SQL Server Helper — Sat, 11 Aug 2012 05:06:54 GMT

Here's a link that shows the different uses of the ISNULL system function:

http://www.sql-server-helper.com/tips/tip-of-the-day.aspx?tkey=1c265f7e-a7f3-4ba5-84e8-7321d5ecfd23&tid=64&tkey=uses-of-the-isnull-system-function

re: What if null if null is null null null is null?

aa — Sat, 09 Feb 2013 10:34:17 GMT

aaa