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

  • May 10, 2010 at 6:36 am

    #1164926

    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.

    Thats what these questions are all about. Small things that slips from our minds...:-)

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG     [font="Arial Black"]here[/font][/url][/right]