title: Naming Boolean (bit) Values in a SQL db
body: <p>The <a href="http://msdn.microsoft.com/en-us/library/ms124438(v=SQL.100).aspx" rel="nofollow noreferrer">AdventureWorks Data Dictionary</a> specifies that the <code>[EmailPromotion]</code> column in the <code>[Contact]</code> table is an <code>int</code> and that:</p>
  
  <pre><code>0 = Contact does not wish to receive e-mail promotions.
  1 = Contact does wish to receive e-mail promotions.
  </code></pre>
  
  <p>and <code>[Employee].[CurrentFlag]</code> uses <code>bit</code> as follows:</p>
  
  <pre><code>0 = Inactive
  1 = Active
  </code></pre>
  
  <p>My question has two parts:</p>
  
  <ul>
  <li>Is there a good reason to use the <code>int</code> datatype in place <code>bit</code> (both uses will be documented)?</li>
  <li>What naming conventions for boolean and boolean-like columns do you recommend? (e.g. IsActive, ActiveFlag, Active) </li>
  </ul>