title: Arithmetic overflow error converting expression to data type smallint
body: <p>I am new to SQL Server, this question might be repeated here. Since i haven't find a solution for my problem. I wished to post here. So here is my problem </p>
  
  <pre><code>select(volume * speed)  from traffic_data_replica;
  </code></pre>
  
  <p>I am trying to multiply values from two columns , data type is smallint for both columns. Error i got is : </p>
  
  <blockquote>
    <p>Msg 8115, Level 16, State 2, Line 1<br>
    Arithmetic overflow error converting expression to data type smallint.</p>
  </blockquote>