将numeric 转换为数据类型 numeric 时发生算术溢出错误
云社区用户C4pi7496
2,378次浏览
编辑于2018年03月09日 18:22:31
商贸版高级版6.0，业务期末结账提示算术溢出，跟踪信息提示：
exec sp_executesql N'
select FUserID, FAccessType, FAccessMask
from t_AccessControl
where FObjectType = @P1 and
(FObjectID = @P2 Or FObjectID = 0)
and (FUserID = @P3 or
FUserID in (select FGroupID from t_Group where FUserID = @P4)) order by FAccessType', N'
@P1 int,@P2 int,@P3 int,@P4 int', 23, 90, 16399, 16399
1.png(469.39KB)
推荐阅读