如何检查 TSQL 中 WHERE 语句中的逻辑比较是 TRUE 还是 FALSE？

Question

我怎样才能完成这个查询，以便我可以检查逻辑比较的结果是否为FALSE：

SELECT *
FROM table1
INNER JOIN table2 ...
INNER JOIN table3 ...
INNER JOIN table4 ...
WHERE ( ( table1.Value IS NULL) AND 
         ( table2.Value IS NULL) AND
         ( table3.Value IS NULL) AND
          ( table4.Value IS NULL) ) -- Here I want to ADD something like IS FALE; 
                                    --How can I do this?

Answer 1

使用 NOT 操作数

SELECT *
FROM table1
INNER JOIN table2 ...
INNER JOIN table3 ...
INNER JOIN table4 ...
WHERE NOT ( ( table1.Value IS NULL) AND 
            ( table2.Value IS NULL) AND
            ( table3.Value IS NULL) AND
            ( table4.Value IS NULL)
          )

Answer 2

您有几个选项

NOT

...(Table4.value IS NOT NULL)...
...NOT (Table4.value IS NULL)...

CASE

CASE WHEN (<复杂比较> = somevalue THEN 1 ELSE 0) = 0< /代码>

Answer 3

您的意思是：

SELECT *
FROM table1
INNER JOIN table2 ...
INNER JOIN table3 ...
INNER JOIN table4 ...
WHERE (
        NOT(    
         ( table1.Value IS NULL) AND 
         ( table2.Value IS NULL) AND
         ( table3.Value IS NULL) AND
         ( table4.Value IS NULL)
          ) 
      )