TechNet
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize
The document is archived and information here might be outdated

@@MAX_PRECISION (Transact-SQL)

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'
Show:
© 2016 Microsoft