title: Why can't I enter an integer value into a decimal field?
body: <p>I'm trying to write an insert statement for a SQL Server table that inserts the value 1 into a decimal field. The field is of the type decimal(10, 10) which, as far as I understand, means that it can have up to 10 digits altogether, and up to 10 of those digits can be after the decimal point. But, when I try to run the insert statement I get the following error:</p>
  
  <pre><code>Arithmetic overflow error converting int to data type numeric.
  </code></pre>
  
  <p>If I change the data type of the field to decimal(11, 10), it suddenly works. What am I not understanding here? What am I doing wrong?</p>