3 ms·
Something to petition ANSI about. (Microsoft's SQL Server still defaults to the non-ANSI NULL behavior where a = b when both are NULL, and that's something tha
by WorldMaker 7y ago
Something to petition ANSI about.
(Microsoft's SQL Server still defaults to the non-ANSI NULL behavior where a = b when both are NULL, and that's something that still pings on checklists of SQL Server if it follows ANSI standards. SQL Server is kind enough to let you enable/disable the behavior, and likely that would persist even after the default switches to meet the standard as the docs assure will happen "in some future version".)
- zvrba 7y agoActually I find this a very practical behavior. It allows me to have NULLs in columns participating in UNIQUE indexes. At least with indexes, it's very intuitive and useful.