<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by pramod singla
»
Nulls
49 posts, Page 2 of 5
««
1
2
3
4
5
»
»»
Nulls
Rate Topic
Display Mode
Topic Options
Author
Message
Toreador
Toreador
Posted Wednesday, December 08, 2010 4:41 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 10:02 AM
Points: 1,383,
Visits: 4,870
da-zero (12/8/2010)
Some people are still working with earlier versions of SQL Server.
But hopefully none of them are still using ANSI_NULLS OFF or any other deprecated features?
Post #1031782
honza.mf
honza.mf
Posted Wednesday, December 08, 2010 5:08 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 1:11 AM
Points: 1,114,
Visits: 1,209
Toreador (12/8/2010)
da-zero (12/8/2010)
Some people are still working with earlier versions of SQL Server.
But hopefully none of them are still using ANSI_NULLS OFF or any other deprecated features?
Some old applications are using ANSI_NULLS OFF.
Try to explain to users that filters of the type
name not like 'honza%'
don't return those lines where name is empty. They don't start with honza...
See, understand, learn, try, use efficient
© Dr.Plch
Post #1031794
steven.malone
steven.malone
Posted Wednesday, December 08, 2010 5:49 AM
SSC Journeyman
Group: General Forum Members
Last Login: Thursday, April 18, 2013 6:58 AM
Points: 96,
Visits: 210
Caution:
Any null values returned by subquery or expression that are compared to test_expression using IN or NOT IN return UNKNOWN. Using null values in together with IN or NOT IN can produce unexpected results
This is not in the local BOL of my work environment. And I have no control over that.
I used to try to answer QOTD based on my knowledge and research in BOL.
But questions like this are the reason I now run the code first and that takes the fun out of it.
Post #1031811
paul s-306273
paul s-306273
Posted Wednesday, December 08, 2010 5:58 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 9:12 AM
Points: 1,167,
Visits: 646
Nice question!
Post #1031816
tommyh
tommyh
Posted Wednesday, December 08, 2010 6:05 AM
UDP Broadcaster
Group: General Forum Members
Last Login: Friday, May 10, 2013 3:15 AM
Points: 1,479,
Visits: 1,943
steven.malone (12/8/2010)
Caution:
Any null values returned by subquery or expression that are compared to test_expression using IN or NOT IN return UNKNOWN. Using null values in together with IN or NOT IN can produce unexpected results
This is not in the local BOL of my work environment. And I have no control over that.
I used to try to answer QOTD based on my knowledge and research in BOL.
But questions like this are the reason I now run the code first and that takes the fun out of it.
This logic i dont get at all. The question is great for showing a "gotcha" in SQL. If it isnt in your BOL... then even better. You just learned something that you dont know and couldnt have found out any other way (since its not in your BOL). The QOTD isnt there for us to score points... its there to teach/spread knowledge. Sometimes its not so good... but then the discussion is normally better. So either way... goal accieved. The points are just a bonus... if you get it right.
Seriously whats the point of running the code... getting your point and then moving along?
/T
Post #1031825
honza.mf
honza.mf
Posted Wednesday, December 08, 2010 6:16 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 1:11 AM
Points: 1,114,
Visits: 1,209
tommyh (12/8/2010)
The QOTD isnt there for us to score points...
It's easy to say this if you have one thousand points
See, understand, learn, try, use efficient
© Dr.Plch
Post #1031831
ronmoses
ronmoses
Posted Wednesday, December 08, 2010 6:21 AM
Say Hey Kid
Group: General Forum Members
Last Login: Yesterday @ 5:48 AM
Points: 661,
Visits: 698
tommyh (12/8/2010)
The QOTD isnt there for us to score points... its there to teach/spread knowledge.
Exactly. I knew I was answering the question incorrectly -- it was the result I would have expected, which is never the right answer in QotDs -- but I went with that answer anyway because I wanted to learn something. I have no idea how many "points" I have, nor do I care, nor do I know what I would do with that information if I had it.
[edit: Okay, now I see how many points I have. And then what, can I trade them in for prizes like skee-ball tickets or something?]
Ron
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
Post #1031833
tommyh
tommyh
Posted Wednesday, December 08, 2010 6:25 AM
UDP Broadcaster
Group: General Forum Members
Last Login: Friday, May 10, 2013 3:15 AM
Points: 1,479,
Visits: 1,943
honza.mf (12/8/2010)
tommyh (12/8/2010)
The QOTD isnt there for us to score points...
It's easy to say this if you have one thousand points
Those points also go up from posting. So in theory i could have answered ALL QOTD wrong and have 1000... 1001 forum posts... so doesnt say that much.
/T
Post #1031835
tommyh
tommyh
Posted Wednesday, December 08, 2010 6:27 AM
UDP Broadcaster
Group: General Forum Members
Last Login: Friday, May 10, 2013 3:15 AM
Points: 1,479,
Visits: 1,943
ronmoses (12/8/2010)
tommyh (12/8/2010)
The QOTD isnt there for us to score points... its there to teach/spread knowledge.
Exactly. I knew I was answering the question incorrectly -- it was the result I would have expected, which is never the right answer in QotDs -- but I went with that answer anyway because I wanted to learn something. I have no idea how many "points" I have, nor do I care, nor do I know what I would do with that information if I had it.
[edit: Okay, now I see how many points I have. And then what, can I trade them in for prizes like skee-ball tickets or something?]
Ron
No you can only compare it to others like Jeff Moden and GilaMonster... and cry
/T
Post #1031837
honza.mf
honza.mf
Posted Wednesday, December 08, 2010 6:41 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 1:11 AM
Points: 1,114,
Visits: 1,209
tommyh (12/8/2010)
honza.mf (12/8/2010)
tommyh (12/8/2010)
The QOTD isnt there for us to score points...
It's easy to say this if you have one thousand points
Those points also go up from posting. So in theory i could have answered ALL QOTD wrong and have 1000... 1001 forum posts... so doesnt say that much.
/T
Yessir. And I now obtain one more point!
Sorry, I have a bad day (or maybe a week) and this to relax a little.
See, understand, learn, try, use efficient
© Dr.Plch
Post #1031848
« Prev Topic
|
Next Topic »
49 posts, Page 2 of 5
««
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
