How to fix error: Arithmetic overflow error converting expression to data type int

Question

I just used count function in query statement but got an error as shown below:

SELECT count(*)
FROM [my_table_data]

Error messages:

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

Please help me to find the solution!

Answer 1

Try BIG_COUNT instead. I believe it's supported since SQL Server 2012

SELECT big_count(*) FROM [my_table_data]