试图减去2列值。 “将表达式转换为tinyint的算术溢出错误 [英] Trying to subtract 2 column values. "Arithmetic overflow error converting expression to tinyint

问题描述

当QtyReceived大于QtyOrdered时，下面的查询会遇到两个数字。如何创建一个接受值的额外列？

谢谢！

The query below falls over when it hits two numbers where QtyReceived is greater than QtyOrdered. How do I create an extra column that will accept the values?
Thanks!

SELECT        CAST(QtyOrdered - QtyReceived AS int) AS Expr1
FROM            tblSales

推荐答案

TINYINT字段不能保留负数 - 因此在进行数学运算之前需要将它们分为整数值：

TINYINT fields cannot hold negative numbers - so you need to caste them to integer values before you do the math:

SELECT CAST(QtyOrdered AS INT) - CAST(QtyReceived AS INT) AS Expr1 FROM tblSales

这篇关于试图减去2列值。 “将表达式转换为tinyint的算术溢出错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！