Post reply

NOT IN Confusion

  • July 29, 2024 at 12:00 am

    #4431745

    Comments posted to this topic are about the item NOT IN Confusion

  • July 29, 2024 at 7:41 am

    #4440669

    Not Exists vs Not In:

    SELECT *

    FROM dbo.Candidates AS c

    WHERE

    NOT exists

    ( SELECT PersonName FROM dbo.Person WHERE Person.PersonName = c.PersonName);

  • July 29, 2024 at 8:10 am

    #4440678

    Compare and contrast "EXCEPT".

     

  • July 31, 2024 at 12:11 pm

    #4441414

    Always an issue of ansi_nulls setting... if run with "set ansi_nulls off", you'll get different output 🙂

  • July 31, 2024 at 1:49 pm

    #4441432

    My preference is to use isnull( PersonName, '' ); even all the way back to the initial table load.  Sloppy input and weak specifications.  (BTW, I have met a man whose last name really is "Null.")

  • July 31, 2024 at 1:51 pm

    #4441433

    My preference is to use isnull( PersonName, '' ); even all the way back to the initial table load.  Sloppy input and weak specifications.  (BTW, I have met a man whose last name really is "Null.")

    Thanks to SQLServerCentral for this poser.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply