Export (0) Print
Expand All
Expand Minimize

Error 1002

SQL Server 2000

Error 1002

Severity Level 16
Message Text

Line %d: Specified scale %d is invalid.


This error occurs when the scale of a decimal or numeric column does not fall between the allowable minimum and maximum values based on the precision of the column.


Specify the precision with p, which must be between 1 and the maximum precision, and the scale with s, which must be between 0 and p. If you do not specify the precision, Microsoft® SQL Server™ uses a default precision of 18. If you do not specify the scale, SQL Server uses a default scale of 0. For more information, see the decimal and numeric topic and the Precision, Scale, and Length.

© 2014 Microsoft