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

  • May 9, 2010 at 11:01 pm

    #1164815

    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.

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