MSSQL: Arithmetic overflow error converting expression to data type int

Today, a boss asked for Monthly Traffic Statistics for the current project over the past year.

Because of the large data volume, each data field was designed with an int, and the maximum int value is 2B.

However, the daily data volume of our system is about 20 MB, and the monthly data volume is about 6B.

Therefore, when sum is used directly at the beginning, an error occurs, indicating that Arithmetic overflow error converting expression to data type int is incorrect.

So before sum, convert the Data Type first.

Cast (accepted as bigint), or cast (accepted as numeric (38,0) or cast (accepted as decimal)

Then

Sum (cast (accepted as bigint) accepted

The problem is solved,