RE: SQL 2000 fails to detect NULL values

From: Yaocuauhtzin (Yaocuauhtzin_at_discussions.microsoft.com)
Date: 10/06/04 

Date: Wed, 6 Oct 2004 16:23:06 -0700

Sorry, I miss some info:

It's work in SQL 7, and fail in SQL 2000 - 8.00.760

I already use:
     option (maxdop 1)
     option (robust plan)
     option (keep plan)
and problem still.

The table 'secuenciales' have 1 field and 1 record only.

Just Now, I work in SQL 7. I need a patch, to avoid to re-write a vey-large
and complex application.

> SELECT B.ID, ISNULL(B.ID,'Is Null')
> FROM secuenciales A
> LEFT JOIN (
> select b.id
> from (select 'Isnt Null' id) b
> LEFT join secuenciales d on 1=0
> ) B ON 1=0
>
>
> ID
> --------- ---------
> NULL Isnt Null
>
> (1 row(s) affected)