SQL 2000 fails to detect NULL values

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

  • Next message: Yaocuauhtzin: "RE: SQL 2000 fails to detect NULL values" 
    Date: Wed, 6 Oct 2004 14:11:01 -0700

    I have this query in SQL 2000, I get wrong answer

    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)

  • Next message: Yaocuauhtzin: "RE: SQL 2000 fails to detect NULL values"

    Relevant Pages

    • Re: Query to return multiple records
      ... Blake wrote: ... Isnt there a way though to do this through ... a querry, All I really want to do is copy like 15 camera serial numbers ... from a column in a spreadsheet and paste it in a query. ...
      (comp.databases.ms-access)
    • Re: Excel and SQL help
      ... Into query table, you add a column to right of last column ... > we have an excel file that gets info from a SQL Server, ... > fine and works well taking data from two tables on our SQL Server, ... > (although it isnt an actual record on SQL Server because its built from ...
      (microsoft.public.excel.programming)
    • Re: Query to return multiple records
      ... Isnt there a way though to do this through ... a querry, All I really want to do is copy like 15 camera serial numbers ... from a column in a spreadsheet and paste it in a query. ... Do you have a website that details changes? ...
      (comp.databases.ms-access)
    • converting access to sql
      ... is there any quick n easy way to convert an old access database to sql ... yes i know it sounds easy and it isnt! ... i need to transfer the data to sql - which has been redesigned with multi ...
      (microsoft.public.sqlserver.server)
    • Re: small selectproblem
      ... isnt there an easier way since only a known number qualify for ... > try following query: ... > Vishal Parkar ...
      (microsoft.public.sqlserver.programming)