IS NULL doesn't work as expected in MSSQL 2000 with no Service Pack on it
- by user306825
The following batch executed on different instances of mssql 2000 illustrates the problem.
select @@version
create table a
(a int)
create table b
(b int)
insert into a(a) values (1)
insert into a(a) values (2)
insert into a(a) values (3)
insert into b(b) values (1)
insert into b(b) values (2)
select * from a
left outer join…
