Ok, Microsoft, what the fuck is
that?
If your code compares two NULL values or a NULL value with any other value, your code will return an unknown result.No, it's not "unknown", it is pretty much very well known and depends on ANSI_NULLS setting. Both cases above return false if ANSI_NULLS is on.
(no subject)
Date: 2012-10-19 07:21 pm (UTC)(no subject)
Date: 2012-10-19 08:10 pm (UTC)(no subject)
Date: 2012-10-19 08:13 pm (UTC)(no subject)
Date: 2012-10-20 04:48 pm (UTC)(no subject)
Date: 2012-10-20 06:55 pm (UTC)