title: SQL Server 2008
body: <pre><code>SELECT CAST('-1'AS TINYINT) 
  </code></pre>
  
  <p>Why this statement gives below error on SQL server R2 but not on SQL server 2016</p>
  
  <blockquote>
    <p>Msg 244, Level 16, State 1, Line 1 <br>
    The conversion of the varchar value '-1' overflowed an INT1 column. Use a larger integer column.</p>
  </blockquote>