Why to use SET ANSI NULLS ON in store procedure?

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

Comments

Popular posts from this blog

Google to FTS Syntax Cheat Sheet

What is difference between DELETE and TRUNCATE commands?

@@trancount