Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ANSI_NULLS Expand / Collapse
Author
Message
Posted Tuesday, May 6, 2008 12:10 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:49 PM
Points: 7,105, Visits: 15,438
Comments posted to this topic are about the item ANSI_NULLS

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Post #495406
Posted Tuesday, May 6, 2008 6:45 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 13,872, Visits: 9,596
Good question. Actually made me turn my brain on and think, and no "how many months have 28 days in them" type tricks.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #495562
Posted Tuesday, May 6, 2008 7:43 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:33 PM
Points: 2,389, Visits: 2,779
I agree. I think this is a great question. I got it wrong, but it showed me I still have more to learn about NULLs.

Thanks,
webrunner


-------------------
"Operator! Give me the number for 911!" - Homer Simpson

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Post #495619
Posted Tuesday, May 6, 2008 9:38 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 16, 2014 4:46 AM
Points: 5,404, Visits: 1,400
The last 3-4 questions are really good. The quality of questions have improved. We should applaud the team. :)


Post #495745
Posted Tuesday, May 6, 2008 11:00 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
Great question. I always had hard time reading value of NULL's. No wonder I got it wrong today.

SQL DBA.
Post #495796
Posted Tuesday, May 6, 2008 11:18 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, September 12, 2012 3:38 PM
Points: 13, Visits: 110
I thought it would be 3,3,3,2,2 instead of the correct 3,2,3,2,2. That shows me that I understand NULL pretty well, just not ANSI_NULLS OFF. It's nice to know that it's going away, then. :)

I've saved these queries for when I have to explain how NULL works to other people.
Post #495810
Posted Tuesday, May 6, 2008 11:37 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 2:56 AM
Points: 2,842, Visits: 3,876
Great Question! I almost stumbeled...

I only would have added this one as well:

SET ANSI_NULLS OFF
SELECT COUNT(ggg) FROM testnull WHERE ggg=1 OR ggg!=1 OR ggg=NULL;


Best Regards,
Chris Büttner
Post #495827
Posted Tuesday, May 6, 2008 11:47 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:49 PM
Points: 7,105, Visits: 15,438
Hey - I think this is a DUMB question, and the author should get smacked around. I mean - sheesh....

Oh wait - never mind...:D

(thanks for the feedback guys!)


----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Post #495837
Posted Tuesday, May 6, 2008 9:58 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 16, 2014 4:46 AM
Points: 5,404, Visits: 1,400
Matt Miller (5/6/2008)
Hey - I think this is a DUMB question, and the author should get smacked around. I mean - sheesh....

Oh wait - never mind...:D

(thanks for the feedback guys!)


If this is a dump question, then we required lot more like this ....



Post #496046
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse