SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
This topic has not yet been rated - Rate this topic

@@MAX_PRECISION (Transact-SQL)

SQL Server 2008 R2

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

Topic link icon Transact-SQL Syntax Conventions

Copy 

@@MAX_PRECISION

By default, the maximum precision returns 38.

Copy 
SELECT @@MAX_PRECISION AS 'Max Precision'
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.