一个SQL语句:
SELECT sum(isnull(Qty,0)) FROM Trans GROUP BY Customer
执行完毕后提示出错。
“Server: Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type int.”要怎么解决这个问题呢?
SELECT sum(isnull(Qty,0)) FROM Trans GROUP BY Customer
执行完毕后提示出错。
“Server: Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type int.”要怎么解决这个问题呢?
FROM Trans GROUP BY Customer
FROM Trans GROUP BY Customer