我正试图获取一列的总数,但当我运行此查询时,出现以下错误。有什么建议吗?
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.