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.

Explanation

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.

Action

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.

Show:
© 2014 Microsoft