http://www.sqlservercentral.com/blogs/sqlwise/2013/08/21/sql-server-three-valued-logic-and-ansi-nulls/

Printed 2014/09/02 08:05AM

SQL Server Three Valued Logic and Ansi Nulls

By Timothy A Wiseman, 2013/08/21

SQL Server uses a three valued logic with True, False, and Unknown. And, normally, SQL Server Nulls are not comparable. Together that means that this little script: normally produces no results. It simply prints the standard ‘Command(s) completed successfully.’ One … Continue reading
Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.