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 2 of 2

««1 2

NULL & 'NULL'

Rate Topic

Display Mode

Topic Options

Author

Message

The Dixie Flatline

Posted Thursday, February 04, 2010 3:01 PM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 9:23 PM
Points: 3,836, Visits: 5,635

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? -- Stephen Stills

Post #859997

Paul White

Posted Tuesday, March 30, 2010 9:11 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 2:43 PM
Points: 10,990, Visits: 10,576

There is nothing good about NULL. Discuss. BigGrin

Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #892903

The Dixie Flatline

Posted Thursday, April 01, 2010 7:28 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 9:23 PM
Points: 3,836, Visits: 5,635

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? -- Stephen Stills

Post #894740

Paul White

Posted Thursday, April 01, 2010 7:42 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 2:43 PM
Points: 10,990, Visits: 10,576

The Dixie Flatline (4/1/2010)

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

Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #894763

« Prev Topic | Next Topic »

14 posts, Page 2 of 2

««1 2

Permissions