Error 2751

Troubleshooting SQL Server

Troubleshooting

Error 2751

Severity Level 16
Message Text

Column or parameter #%d: Specified column scale %d is greater than the specified precision of %d.

Explanation

This error occurs when the scale of a decimal or numeric column exceeds the precision value for that column.

For decimal and numeric data types, Microsoft® SQL Server™ normally supports a maximum precision of 38 digits for compatibility with various applications. For more information about running the sqlservr application, see sqlservr Application.

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, SQL Server uses a default precision of 18. If you do not specify the scale, SQL Server uses a default scale of 0.

See Also

decimal and numeric

Errors 2000-2999

float and real

Precision, Scale, and Length