Difference between revisions of "Sql Server 2012 - Three-Valued Logic"
From MyWiki
(Created page with "The type of logic used in such a case is known as two-valued logic. The WHERE filter returns only the rows for which the predicate evaluates to true<br>") |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
case is known as two-valued logic. The WHERE filter returns only the rows for which the predicate | case is known as two-valued logic. The WHERE filter returns only the rows for which the predicate | ||
evaluates to true<br> | evaluates to true<br> | ||
| + | A predicate can evaluate | ||
| + | to true, false, and unknown. This type of logic is known as three-valued logic<br> | ||
| + | When region is NULL, the predicate region <> <br> | ||
| + | 'WA' evaluates to unknown, and the row is discarded | ||
Latest revision as of 12:44, 25 April 2016
The type of logic used in such a
case is known as two-valued logic. The WHERE filter returns only the rows for which the predicate
evaluates to true
A predicate can evaluate
to true, false, and unknown. This type of logic is known as three-valued logic
When region is NULL, the predicate region <>
'WA' evaluates to unknown, and the row is discarded
