"ANSI NULL Default" documentation confusing - by Martin Smith

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 774632 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 12/18/2012 6:36:27 AM
Access Restriction Public


From http://msdn.microsoft.com/en-us/library/ms188124.aspx


Specify the default behavior of the Equals (=) and Not Equal To (<>) comparison operators when used with null values. Possible values are True (on) and False (off). For more information, see SET ANSI_NULL_DFLT_ON (Transact-SQL) and SET ANSI_NULL_DFLT_OFF (Transact-SQL).
Sign in to post a comment.
Posted by DaveBolt on 7/16/2015 at 7:32 AM
Hmmm - what's ANSI_NULL_DFLT_ON got to do with ANSI?

I suspect someone at Redmond got confused by all the pretty options and called it "ANSI Null Default" instead of just "Null Default" :). After all you can CREATE TABLE t (x int NULL), but you can't CREATE TABLE t (x int ANSI NULL). Maybe the confusing name of the option confused the documenter, who confused us. Probably also confused the developer who implemented it, since it doesn't always work (see https://connect.microsoft.com/SQLServer/Feedback/Details/651164).

In future when the ANSI_NULL option dies (see https://msdn.microsoft.com/en-us/library/ms188048.aspx), hopefully ANSI_NULL_DFLT_ON will stay (or get a better name :)

Thank you sorting out this part of the problem.
Posted by DaveBolt on 7/16/2015 at 6:02 AM
Thank you for fixing this - it got me several times over the years. I can confirm the offline BOL is correct now after updating.
Posted by Rick [MSFT] on 8/9/2013 at 9:40 AM
Finally got around to fixing this. The correction will appear the next time the online versions of Books Online are refreshed. Thank you for submitting this.
Posted by Rick [MSFT] on 12/26/2012 at 8:37 AM
Thank you for reporting this. I will look into it.