Arithmetic overflow on column sum in sql server
I’m trying to get a column total but when i run this query i get the following error. Any advice?
SELECT SUM(Size) as total FROM AllDocs Where DirName LIKE 'sites/test/test%' ERROR: Msg 8115, Level 16, State 2, Line 1 Arithmetic overflow error converting expression to data type int. Warning: Null value is eliminated by an aggregate or other SET operation.
One Solution collect form web for “Arithmetic overflow on column sum in sql server”
While all your sizes can fit into
INT (up to
2^31 - 1), their
Cast them into
SELECT SUM(CAST(Size AS BIGINT)) as total FROM AllDocs WHERE DirName LIKE 'sites/test/test%'