ANSI_NULLS

  • 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?

  • 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

  • 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

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • The last 3-4 questions are really good. The quality of questions have improved. We should applaud the team. 🙂

  • Great question. I always had hard time reading value of NULL's. No wonder I got it wrong today.

    SQL DBA.

  • 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.

  • 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

  • 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?

  • 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 ....:cool:

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply