Home Forums Article Discussions Article Discussions by Author Discuss content posted by lloyd monteiro Values <> null RE: Values <> null

  • May 9, 2010 at 11:14 pm

    #1164819

    Atif Sheikh (5/9/2010)

    Set ANSI_NULLS off / on changes the results.

    By default in database settings it is set to OFF.

    But in SSMS --> Tools --> Options, go to Query Execution --> SQL Server --> ANSI Tab. Here it is set to On. Means, for the query editor window, settings is set to On BY DEFAULT.

    Bit Confusing. 🙂

    And I go the point.

    Ah true, I forgot about the different default settings between database and SSMS (or Query Analyzer for SQL2000). I stand corrected.

    Urbis, an urban transformation company