@@MAX_PRECISION (T-SQL)

Returns the level of precision 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 is 28; however, a larger precision can be set by using the /p switch with sqlservr when starting Microsoft® SQL Server™ from a command prompt.

Examples

SELECT @@MAX_PRECISION

See Also