NULL & 'NULL'

Question

NULL & 'NULL'

VM-723206

SSCrazy

Points: 2964
More actions
February 3, 2010 at 9:40 pm

#218826

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

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Thanks for the question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

ziangij SSCrazy Eights Points: 8066 More actions · Answer 2

ziangij

SSCrazy Eights

Points: 8066

February 3, 2010 at 11:38 pm

#1113484

simple one, thanks 🙂

jshailendra SSCrazy Points: 2260 More actions · Answer 3

jshailendra

SSCrazy

Points: 2260

February 4, 2010 at 12:03 am

#1113493

very simple..but good Q for beginers

vineitnarayansingh SSC Rookie Points: 44 More actions · Answer 4

Good post to understand the difference between 'NULL' and Null....;-)

Bhavesh_Patel SSCrazy Points: 2259 More actions · Answer 5

Nice Question for Beginners ... 🙂

[font="System"]Bhavesh Patel[/font]

http://bhaveshgpatel.wordpress.com/

iceman26 SSC-Addicted Points: 428 More actions · Answer 6

For once in a long while, an uncontroversial answer 🙂

ronmoses@gmail.com SSCarpal Tunnel Points: 4480 More actions · Answer 7

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

JF1081 SSC Eights! Points: 982 More actions · Answer 8

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.

Julie Breutzmann Hall of Fame Points: 3637 More actions · Answer 9

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

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 10

For more fun.....

declare @t1 table (id1 int identity(1,1) primary key, [null] varchar(20))

insert into @t1 values('Null')

insert into @t1 values(null)

insert into @t1 values(default)

declare @t2 table (id2 int identity(11,1) primary key, [null] varchar(20))

insert into @t2 values('Null')

insert into @t2 values(null)

insert into @t2 values(default)

select * from @t1

select * from @t2

select *

from @t1 t1

cross join @t2 t2

where t1.[null] <> t2.[null]

select *

from @t1 t1

cross join @t2 t2

where t1.[null] = t2.[null]

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Paul White SSC Guru Points: 150467 More actions · Answer 11

There is nothing good about NULL. Discuss. 😀

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 12

The problem is about to go away. See Steve's Editorial for April 1, 2010.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Paul White SSC Guru Points: 150467 More actions · Answer 13

The Dixie Flatline (4/1/2010)
The problem is about to go away. See Steve's Editorial for April 1, 2010.

🙂

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi