title: How to check from multiple Boolean columns at least one is true or all column values are false in SQL Server
body: <p>Table format:</p>
  
  <pre><code>+---------+---------+-----------------+
  | column1 | column2 | column3| column4| 
  +---------+---------+-----------------+
  | value1  | true    | true   | false  |
  | value2  | true    | false  | true   |
  | value4  | false   | false  | false  |
  +---------+---------+-----------------+
  </code></pre>
  
  <p>Column 1 to 4 has data type Boolean.  </p>
  
  <p>I want to check whether all these Boolean column values are false or at least one column value is true. </p>
  
  <p>Is there any better way to do this using a SQL Server query?
  Expected output:</p>
  
  <pre><code>+---------+---------+-----------------+
  | column1 | column2 | column3| column4| 
  +---------+---------+-----------------+
  | value1  | true    | true   | false  | = true
  | value2  | true    | false  | true   | = true
  | value4  | false   | false  | false  | = false
  +---------+---------+-----------------+
  </code></pre>