SET ANSI_NULLS ON - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SET ANSI_NULLS ON

Author

Topic

mhbdba
Starting Member

8 Posts

Posted - 2007-09-21 : 12:50:24

What does this mean and do?

SET ANSI_NULLS ON

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-09-21 : 13:18:57

Read up books on line.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

Kristen
Test

22859 Posts

Posted - 2007-09-21 : 13:19:56

Best to read up about it in Books Online.

The ANSI_NULLS setting controls what the behaviour will be of

WHERE Foo = Bar

where both Foo and Bar are NULL.

Normally two NULL values will not be considered "equal", but you can force them to be using an ANSI_NULL setting

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources