Search

"ANSI NULL Default" documentation confusing by Martin Smith

Active

1
0
Sign in
 to vote
Type: Bug
ID: 774632
Opened: 12/18/2012 6:36:27 AM
Access Restriction: Public
0
Workaround(s)
0
User(s) can reproduce this bug
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).
Details (expand)

Product Language

English

Version

SQL Server 2012 - Standard Edition

Category

Documentation

Operating System

Not Applicable

Operating System Language

Not Applicable

Steps to Reproduce

The "ANSI_NULL_DFLT_ON" options relate to the default nullability of newly created columns not how equality comparisons involving NULL are carried out. Is this a copy/paste error or does this database option control both behaviours?

Actual Results

N/A

Expected Results

N/A

Platform

 

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Posted by Microsoft on 12/26/2012 at 8:37 AM
Thank you for reporting this. I will look into it.
Sign in to post a workaround.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement