Home >> Dababase Interview Questions >> Sql Server Interview Questions

Why to use SET ANSI NULLS ON in store procedure

Posted on January 11th , 2012 by Admin

When SET ANSI NULLS ON it means ISO Standard is being followed. = and <> should not be used for null comparison.Instead use is null and is not null