4 ms·
Only if you explicitly turn the ANSI_NULLs option off, IIRC more conformant behaviour has been the default since at least version 7. Of course it does still ha
by dspillett 15y ago
Only if you explicitly turn the ANSI_NULLs option off, IIRC more conformant behaviour has been the default since at least version 7.
Of course it does still have irritations like trailing spaces not being considered significant in string comparisons (to pluck a random example from the air) but so do other databases, especially those that have been around many years so have their on legacy to be backwardly compatible with lest the users revolt, including Oracle (empty strings being considered NULL for instance).