title: SQL Server - BIT data type Issue
body: <p>I have a table in my SQL Server 2012 as follows,</p>
  
  <pre><code>CREATE TABLE TEST (ID INT,NAME VARCHAR(100),STATUS BIT);
  </code></pre>
  
  <p>I inserted the data like this, by mistake,</p>
  
  <pre><code>INSERT INTO TEST SELECT 1,'A',2;
  </code></pre>
  
  <p>When I queried the result, I found the column "STATUS" storing "1". Whatever value I insert instead of "0", it stores "1". I felt if I define a column as BIT then it should not allow inserting any value apart from 0 and 1.</p>
  
  <p>Is there any trace flag that restricts such insertion? I'm using SQL Server 2012 SP3 now.</p>