@@MAX_PRECISION

Transact-SQL Reference

Transact-SQL Reference

@@MAX_PRECISION

Returns the precision level used by decimal and numeric data types as currently set in the server.

Syntax

@@MAX_PRECISION

Return Types

tinyint

Remarks

By default, the maximum precision returns 38.

Examples
SELECT @@MAX_PRECISION

See Also

Configuration Functions

decimal and numeric

Precision, Scale, and Length