SQL @@MAX_PRECISION

SQL @@MAX_PRECISION is one of the Configuration Function, which will return the maximum precision value used by the Decimal and Numeric data type in SQL Server. By default, this scalar function will return 38. And the Syntax behind this is

@@MAX_PRECISION

SQL @@MAX_PRECISION Example

The code snippet will show the Maximum precision value used by the Numeric and Decimal data types in SQL Programming.

SELECT @@MAX_PRECISION AS 'Maximum Precision Value'
SQL @@MAX_PRECISION 1
Categories SQL