@@MAX_PRECISION (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns the precision level used by decimal and numeric data types as currently set in the server.

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

Configuration Functions (Transact-SQL)
decimal and numeric (Transact-SQL)
Precision, Scale, and Length (Transact-SQL)