May 6, 2008 at 12:10 am
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?
May 6, 2008 at 6:45 am
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
May 6, 2008 at 7:43 am
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
May 6, 2008 at 9:38 am
The last 3-4 questions are really good. The quality of questions have improved. We should applaud the team. 🙂
May 6, 2008 at 11:00 am
Great question. I always had hard time reading value of NULL's. No wonder I got it wrong today.
SQL DBA.
May 6, 2008 at 11:18 am
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.
May 6, 2008 at 11:37 am
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
May 6, 2008 at 11:47 am
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?
May 6, 2008 at 9:58 pm
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