Home > IT Answers > Development > Upper limit for numeric fields
Mozie
10 pts.
 Upper limit for numeric fields
Programming, SQL Server 2000, Visual Basic
What is the maximum numeric field length for Visual Basic Applications running on SQL 2000

Software/Hardware used:
ASKED: January 4, 2008  10:46 AM
UPDATED: January 4, 2008  8:46 PM
RELATED QUESTIONS
Answer Wiki:
Each data type has it's own value range. TINYINT 0-255 SMALLINT -32,768 - 32,767 INT -2,147,483,648 - 2,147,483,647 BIGINT -9,223,372,036,854,775,808 - 9,223,372,036,854,775,807 For a NUMERIC and DECIMAL field the maximum precision is 38. Depending on the value of the scale will deturmin the min and max value that you can store in the field.
Last Wiki Answer Submitted:  January 4, 2008  8:44 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.