Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the precision level used by decimal and numeric data types as currently set in the server.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
@@MAX_PRECISION
Return Types
tinyint
Remarks
By default, the maximum precision returns 38.
Examples
SELECT @@MAX_PRECISION AS 'Max Precision'
See Also
Reference
Configuration Functions (Transact-SQL)
decimal and numeric (Transact-SQL)
Precision, Scale, and Length (Transact-SQL)