Decimal数据类型导致表创建错误

Question

我正在尝试创建此表，它给出错误"小数位数必须为0且总位数">

Create Table DBL2.WorkOrderRouting
(
WorkOrderID int,
ProductID  Varchar(10),
OperationSequence int,
LocationID Varchar(10),
ScheduledStartDate Date,
ScheduledEndDate Date,
ActualStartDate Date,
ActualEndDate Date,
ActualResourceHrs Decimal (1,2),
PlannedCost Decimal (2,2),
ActualCost Decimal (2,5)
) Primary Index (WorkOrderID,ProductID,OperationSequence);

小数似乎很好，我不明白。问题出在哪里！

Answer 1

您需要以另一种方式指定DECIMAL。第一个值需要高于第二个值：

Create Table DBL2.WorkOrderRouting
(
WorkOrderID int,
ProductID  Varchar(10),
OperationSequence int,
LocationID Varchar(10),
ScheduledStartDate Date,
ScheduledEndDate Date,
ActualStartDate Date,
ActualEndDate Date,
ActualResourceHrs Decimal (3,2),
PlannedCost Decimal (4,2),
ActualCost Decimal (7,5)
) Primary Index (WorkOrderID,ProductID,OperationSequence);

---

您可以在文档中找到以下示例：

考虑数字256.78。其类型为DECIMAL(5,2(