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 4, 2010 3:01 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, August 17, 2014 3:10 PM
Points: 2,787, Visits: 6,098
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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 9:36 PM
Points: 9,927, Visits: 11,189
There is nothing good about NULL. Discuss.



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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, August 17, 2014 3:10 PM
Points: 2,787, Visits: 6,098
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 1, 2010 7:42 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 9:36 PM
Points: 9,927, Visits: 11,189
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