@@MAX_PRECISION (Transact-SQL)

@@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

  
@@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)

Community Additions

ADD
Show:
© 2016 Microsoft