Home Forums Article Discussions Article Discussions by Author Discuss content posted by david.wright-948385 set ansi_nulls RE: set ansi_nulls

  • June 2, 2010 at 3:26 am

    #1175159

    sharath.chalamgari (6/2/2010)

    if you use IS NULL then there will not be any effect on the ANSI_NULLS settings

    agreed... i executed the query on sql 2005; ANSI NULLS on/off doesn't make any difference.