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 12»»

NULL & 'NULL' Expand / Collapse
Author
Message
Posted Wednesday, February 03, 2010 9:40 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, July 23, 2013 6:34 AM
Points: 654, Visits: 265
Comments posted to this topic are about the item NULL & 'NULL'
Post #859304
Posted Wednesday, February 03, 2010 11:30 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 10:42 AM
Points: 20,460, Visits: 14,086
Thanks for the question.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #859345
Posted Wednesday, February 03, 2010 11:38 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 2:13 AM
Points: 1,865, Visits: 368
simple one, thanks
Post #859351
Posted Thursday, February 04, 2010 12:03 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, December 11, 2013 7:12 AM
Points: 366, Visits: 455
very simple..but good Q for beginers
Post #859361
Posted Thursday, February 04, 2010 2:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, March 25, 2010 4:43 AM
Points: 38, Visits: 3
Good post to understand the difference between 'NULL' and Null....
Post #859447
Posted Thursday, February 04, 2010 5:35 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, January 11, 2013 12:41 PM
Points: 621, Visits: 297
Nice Question for Beginners ...



Bhavesh Patel

http://bhaveshgpatel.wordpress.com/
Post #859545
Posted Thursday, February 04, 2010 7:14 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, November 28, 2013 4:38 AM
Points: 384, Visits: 204
For once in a long while, an uncontroversial answer
Post #859642
Posted Thursday, February 04, 2010 7:33 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: Monday, April 14, 2014 10:58 AM
Points: 819, Visits: 832
vitesh.bhana (2/4/2010)
For once in a long while, an uncontroversial answer


Really! My favorite part of QotD is the ensuing argument! "I ran the script on 2005 Express with CONCAT_NULL_YIELDS_NULL set to OFF and I got a different result!!!" That's when things get fun!

(No, I didn't.)

Ron Moses


-----
a haiku...

NULL is not zero
NULL is not an empty string
NULL is the unknown
Post #859654
Posted Thursday, February 04, 2010 9:33 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 07, 2010 8:13 AM
Points: 436, Visits: 322
So I was like, of course they are null. you do not ahve to set it to null it is already null so of course the answer is A.
Then I slapped my forehead when I realized I missed the single quotes in the select @v1 = 'NULL' line.
Post #859743
Posted Thursday, February 04, 2010 10:54 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: Friday, April 11, 2014 9:42 AM
Points: 897, Visits: 1,685
ronmoses (2/4/2010)

Really! My favorite part of QotD is the ensuing argument!
Ron Moses

Me, too. I often learn more from the ensuing discussions.

Julie
Post #859813
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse