Understanding NULL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by muzahm » Understanding NULL

14 posts, Page 2 of 2

««1 2

Understanding NULL

Rate Topic

Display Mode

Topic Options

Author

Message

Anipaul

Posted Wednesday, November 19, 2008 12:44 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 6:03 AM
Points: 4,786, Visits: 1,335

Great one. I got confused whether there is something wrong. It was a clever question. But with Set Ansi_Nulls off we are getting different result.

Post #604928

notquitexena

Posted Wednesday, November 19, 2008 10:34 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, November 02, 2009 8:46 AM
Points: 875, Visits: 313

Thanks to Tao Klerks and Archie Flockhart for a very edifying discussion of nulls. I've saved your comments into my sql server reference folder.

-- Save the planet. It's where I keep all my stuff.

Post #605282

Carlton Leach

Posted Wednesday, November 19, 2008 2:40 PM

SSC Eights!

Group: General Forum Members
Last Login: Today @ 6:52 AM
Points: 863, Visits: 1,022

with ansi nulls on: NULL is like a black hole that converts anything it comes into contact with to NULL as well. Kind of like a vampire, NULL bites other values on the neck then what do you know, there vampries (NULL) to.

This is of course if you do not use ISNULL/IS NULL which is like garlic for NULL.

Carlton..

Post #605420

kapil_kk

Posted Wednesday, January 16, 2013 2:32 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:16 PM
Points: 1,061, Visits: 1,151

nice question and excellent explanation from you guys

Post #1407697

« Prev Topic | Next Topic »

14 posts, Page 2 of 2

««1 2

Permissions