max-precision-transact-sql.md

title	@@MAX_PRECISION (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	09/18/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.service
ms.component	t-sql|functions
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	@@MAX_PRECISION_TSQL @@MAX_PRECISION
dev_langs	TSQL
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
ms.assetid	9e7158a1-e503-422a-b326-3c9b06e181b2
caps.latest.revision	30
author	edmacauley
ms.author	edmaca
manager	craigg
ms.workload	Inactive

@@MAX_PRECISION (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]

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

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)