ANSI_NULLS

Question

ANSI_NULLS

Matt Miller (4)

SSC Guru

Points: 124210
More actions
May 6, 2008 at 12:10 am

#190287

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?

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

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

GSquared SSC Guru Points: 260824 More actions · Answer 1

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

webrunner SSC-Dedicated Points: 31863 More actions · Answer 2

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

Anipaul SSC-Insane Points: 24681 More actions · Answer 3

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

SanjayAttray SSChampion Points: 13157 More actions · Answer 4

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

SQL DBA.

Michael Sallmen SSC Enthusiast Points: 181 More actions · Answer 5

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.

Christian Buettner-167247 SSChampion Points: 13729 More actions · Answer 6

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

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 7

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?

Anipaul SSC-Insane Points: 24681 More actions · Answer 8

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: