In SQL Server, the @@MAX_PRECISION configuration function returns the precision level used by decimal and numeric data types as currently set in the server.

No argument is required. You can simply use it in a SELECT statement to return the precision level of the current server.

Example

Here’s an example to demonstrate.

SELECT @@MAX_PRECISION AS [Max Precision];

Result:

+-----------------+
| Max Precision   |
|-----------------|
| 38              |
+-----------------+

The return value is tinyint. By default, the maximum precision returns 38.