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 Thursday, February 04, 2010 3:01 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, April 14, 2014 7:45 AM
Points: 3,949, Visits: 5,944
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
Posted Tuesday, March 30, 2010 9:11 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:04 PM
Points: 11,168, Visits: 10,933
There is nothing good about NULL. Discuss.



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #892903
Posted Thursday, April 01, 2010 7:28 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, April 14, 2014 7:45 AM
Points: 3,949, Visits: 5,944
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
Posted Thursday, April 01, 2010 7:42 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:04 PM
Points: 11,168, Visits: 10,933
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 »

Add to briefcase ««12

Permissions Expand / Collapse