Arithmetic overflow error converting expression to data type smallint

Question

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

select(volume * speed)  from traffic_data_replica;

I am trying to multiply values from two columns , data type is smallint for both columns. Error i got is :

Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type smallint.

Gordon Linoff · Accepted Answer · 2014-02-11 13:04:02Z

7

Cast one of the values to a "bigger" type before the calculation:

select cast(volume as int) * speed
from traffic_data_replica;

You can also do this easily by multiplying by 1.0:

select 1.0*volume*speed
from  traffic_data_replica

answered Feb 11, 2014 at 13:04

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

bibinmatthew Over a year ago

This was really a good information :) @Gordon Linoff Really thankful to you . "Information is wealth"

Collectives™ on Stack Overflow

Arithmetic overflow error converting expression to data type smallint

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related