"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.


1
0
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

Description

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

ANSI NULL Default

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 Microsoft 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 Microsoft on 12/26/2012 at 8:37 AM
Thank you for reporting this. I will look into it.