max-precision-transact-sql.md

title	@@MAX_PRECISION (Transact-SQL)
description	@@MAX_PRECISION (Transact-SQL)
author	markingmyname
ms.author	maghan
ms.date	09/18/2017
ms.service	sql
ms.subservice	t-sql
ms.topic	reference
ms.custom	ignite-2025
f1_keywords	@@MAX_PRECISION_TSQL @@MAX_PRECISION
helpviewer_keywords	precision [SQL Server], @@MAX_PRECISION numeric data type, precision level decimal data type, precision level @@MAX_PRECISION function data types [SQL Server], precision
dev_langs	TSQL

@@MAX_PRECISION (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance FabricSQLDB]

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

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

@@MAX_PRECISION  

Return Types

tinyint

Remarks

By default, the maximum precision returns 38.

Examples

SELECT @@MAX_PRECISION AS 'Max Precision'  

See Also

Configuration Functions (Transact-SQL)
decimal and numeric (Transact-SQL)
Precision, Scale, and Length (Transact-SQL)