title: Casting INT to bit in SQL Server
body: <p>What would happen if I cast an <code>INT</code> to a <code>BIT</code> when <code>INT</code> value is 0 and <code>INT</code> value is different from 0?</p>
  
  <p>Like: </p>
  
  <pre><code>SELECT CAST (0 AS bit)
  </code></pre>
  
  <p>or </p>
  
  <pre><code>SELECT CAST (10 AS bit)
  </code></pre>