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 ««12345»»»

NULL Expand / Collapse
Author
Message
Posted Tuesday, April 13, 2010 1:18 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, November 27, 2014 5:23 AM
Points: 1,425, Visits: 1,316
Sorry: NULL IS NULL.




See, understand, learn, try, use efficient
© Dr.Plch
Post #902175
Posted Tuesday, April 13, 2010 1:19 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, September 25, 2014 12:38 PM
Points: 1,385, Visits: 1,249
Hah, should have known Hugo would come explain everything properly - ignore my posts, concentrate on his :)


http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
Post #902177
Posted Tuesday, April 13, 2010 1:37 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:51 PM
Points: 4,651, Visits: 11,108
I got my point because I could guess the spirit of the question from the "UNKNOWN" option, but it's plain wrong.
NULL := NULL


--
Gianluca Sartori

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Post #902180
Posted Tuesday, April 13, 2010 2:26 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 2:56 AM
Points: 2,842, Visits: 3,876
Hugo Kornelis (4/13/2010)
[wrote lots of good stuff...]


Thanks for this excellent clarification which deserves an Article on its own! So you better get started!


Best Regards,
Chris Büttner
Post #902193
Posted Tuesday, April 13, 2010 2:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:32 PM
Points: 6,128, Visits: 8,393
Christian Buettner-167247 (4/13/2010)
Hugo Kornelis (4/13/2010)
[wrote lots of good stuff...]


Thanks for this excellent clarification which deserves an Article on its own! So you better get started!
Thanks, Chris!

I already wrote and published that article some years ago. Just not here, but on my blog. See the links in my first post.



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #902198
Posted Tuesday, April 13, 2010 2:40 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 1:59 AM
Points: 805, Visits: 1,195
I opted for the NULL answer. My understanding was, and still is, that NULL doesn't mean unknown, but that any potential value is simply not there.



Regards,
Cath

"Hang on lads, I've got a great idea. "
Michael Caine (Charlie Croker) The Italian Job
Post #902199
Posted Tuesday, April 13, 2010 5:05 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:52 AM
Points: 2,284, Visits: 537
For me, NULL is definitely not «Unknown», since «Unknown» is a result of a logical operation.
Being in doubt i voted for NULL, but the question should have had more explanation.
Post #902283
Posted Tuesday, April 13, 2010 6:31 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, December 8, 2014 10:20 AM
Points: 170, Visits: 235
NULL means the absense of a value....

NULL means NULL.

NULL does not equal NULL which is very different statement from means.


Kev -=Conan The Canadian=-
@ConanTheCdn
Post #902335
Posted Tuesday, April 13, 2010 6:41 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, November 27, 2014 5:23 AM
Points: 1,425, Visits: 1,316
And what about not mentioned option "empty value". For numerics it is clear, but for strings, it's dangerous to mix with empty string.
NULL is unassigned value - no value at all, UKNOWN is special logical value, and zero/'' are normal values.




See, understand, learn, try, use efficient
© Dr.Plch
Post #902342
Posted Tuesday, April 13, 2010 7:08 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 8:00 AM
Points: 892, Visits: 2,473
For a question about NULL to make any sense, the context and/or the operational definition must be set.

NULL has different results in the same operations based on other settings, therefore, NULL has different definitions based on those settings.

None of that is counting certain segments of actual practice, (not theory) in which the operational definition of NULL is actually 'Treat it as you treat empty string or 0 or some other known value, because those who came before failed to set the column to be NOT NULL for one or more reasons, and we aren't allowed to change the data or the setting now'.
Post #902362
« Prev Topic | Next Topic »

Add to briefcase ««12345»»»

Permissions Expand / Collapse