SQL @@MAX_PRECISION is one of the Configuration Function, which will return the maximum precision value used by the Decimal and Numeric data type in SQL Server. By default, this scalar function will return 38. And the Syntax behind this is



Below code snippet will show the Maximum precision value used by the Numeric and Decimal data type in  SQL Server.

SELECT @@MAX_PRECISION AS 'Maximum Precision Value'

About Suresh

Suresh is the founder of TutorialGateway and a freelance software developer. He specialized in Designing and Developing Windows and Web applications. The experience he gained in Programming and BI integration, and reporting tools translates into this blog. You can find him on Facebook or Twitter.