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.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Returns the precision level used by decimal and numeric data types as currently set in the server.
Transact-SQL syntax conventions
@@MAX_PRECISION
tinyint
By default, the maximum precision returns 38.
SELECT @@MAX_PRECISION AS 'Max Precision'
Configuration Functions (Transact-SQL)
decimal and numeric (Transact-SQL)
Precision, Scale, and Length (Transact-SQL)