@@MAX_PRECISION (Transact-SQL)

@@MAX_PRECISION (Transact-SQL)

 

THIS TOPIC APPLIES TO: yesSQL Server yesAzure SQL Database noAzure 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

By default, the maximum precision returns 38.

SELECT @@MAX_PRECISION AS 'Max Precision'

Community Additions

ADD
Show:
© 2016 Microsoft