How do I interpret precision and scale of a number in a database?

by

Numeric precision refers to the maximum number of digits that are present in the number.

ie 1234567.89 has a precision of 9

Numeric scale refers to the maximum number of decimal places

ie 123456.789 has a scale of 3

Thus the maximum allowed value for decimal(5,2) is 999.99

More Related Contents:

  1. SQL Data models
  2. How to randomly select rows in SQL?
  3. What’s the difference between TRUNCATE and DELETE in SQL
  4. SQL best practice to deal with default sort order
  5. Remove trailing zeros from decimal in SQL Server
  6. How can I get column names from a table in Oracle?
  7. single fixed table with multiple columns vs flexible abstract tables
  8. How many rows in a database are TOO MANY?
  9. Write a number with two decimal places SQL Server
  10. How can I send email from PostgreSQL trigger?
  11. How to design a database for User Defined Fields?
  12. How to run a stored procedure in sql server every hour?
  13. Composite Primary key vs additional “ID” column?
  14. Questions every good Database/SQL developer should be able to answer [closed]
  15. Why do you create a View in a database?
  16. Logging ALL Queries on a SQL Server 2008 Express Database?
  17. Best database field type for a URL
  18. MySQL – how to front pad zip code with “0”?
  19. How can I implement SQL INTERSECT and MINUS operations in MS Access
  20. Postgres Error: More than one row returned by a subquery used as an expression
  21. Does ‘Select’ always order by primary key?
  22. How do I create and query linked database servers in SQL Server?
  23. How do I change db schema to dbo
  24. What is the best way to implement soft deletion?
  25. PostgreSQL how to create a copy of a database or schema?
  26. Query a Table’s Foreign Key relationships
  27. Historical / auditable database
  28. Postgres: convert single row to multiple rows (unpivot)
  29. How to store a list in a db column
  30. Copy table structure to new table in sqlite3

Leave a Comment