NULL & 'NULL'

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by VM » NULL & 'NULL'

14 posts, Page 1 of 2

1 2 »»

NULL & 'NULL'

Rate Topic

Display Mode

Topic Options

Author

Message

VM-723206

Posted Wednesday, February 03, 2010 9:40 PM

SSChasing Mays

Group: General Forum Members
Last Login: Saturday, April 06, 2013 12:20 AM
Points: 649, Visits: 263

Comments posted to this topic are about the item NULL & 'NULL'

Post #859304

SQLRNNR

Posted Wednesday, February 03, 2010 11:30 PM

SSCoach

Group: General Forum Members
Last Login: Today @ 5:03 PM
Points: 18,853, Visits: 12,438

Thanks for the question.

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

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

ziangij

Posted Wednesday, February 03, 2010 11:38 PM

SSCommitted

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:53 AM
Points: 1,551, Visits: 359

simple one, thanks Smile

Post #859351

jshailendra

Posted Thursday, February 04, 2010 12:03 AM

Old Hand

Group: General Forum Members
Last Login: Friday, December 21, 2012 5:24 AM
Points: 366, Visits: 436

very simple..but good Q for beginers

Post #859361

vineitnarayansingh

Posted Thursday, February 04, 2010 2:43 AM

SSC 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.... Wink

Post #859447

Bhavesh_Patel

Posted Thursday, February 04, 2010 5:35 AM

SSChasing Mays

Group: General Forum Members
Last Login: Friday, January 11, 2013 12:41 PM
Points: 621, Visits: 297

Nice Question for Beginners ... Smile

Bhavesh Patel

http://bhaveshgpatel.wordpress.com/

Post #859545

vitesh.bhana

Posted Thursday, February 04, 2010 7:14 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:31 AM
Points: 382, Visits: 196

For once in a long while, an uncontroversial answer Smile

Post #859642

ronmoses

Posted Thursday, February 04, 2010 7:33 AM

Say Hey Kid

Group: General Forum Members
Last Login: Today @ 5:48 AM
Points: 661, Visits: 698

vitesh.bhana (2/4/2010)

For once in a long while, an uncontroversial answer Smile

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

JF1081

Posted Thursday, February 04, 2010 9:33 AM

SSC-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

Julie Breutzmann

Posted Thursday, February 04, 2010 10:54 AM

SSC Eights!

Group: General Forum Members
Last Login: Today @ 9:30 AM
Points: 814, Visits: 1,603

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 »

14 posts, Page 1 of 2

1 2 »»

Permissions