Column or parameter #%d: Specified column precision %d is greater than the maximum precision of %d.
This error occurs when the precision of a float, decimal, or numeric column exceeds the maximum value for the specified data type.
For decimal and numeric data types, Microsoft® SQL Server™ normally supports a maximum precision of 28 digits for compatibility with various front ends, such as Microsoft Visual Basic®. However, if a precision greater than 28 is desired, use the /p parameter of the sqlservr application from a Win32® command prompt. For more information about running the sqlservr application, see sqlservr Application.
Define the column to have a precision that falls within the allowable precision range for that data type.
| decimal and numeric | Precision, Scale, and Length |
| float and real |