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

Below code snippet will show the Maximum precision value used by the Numeric and Decimal data type in  SQL Server.

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