Precision and Scale ?
-
Hello, I have been trying to develop an automatic way of programmatically accessing datasources and performing some predefined(-supported) processing on them. The question I would like to ask you people has to do with numeric fields. What exactly is precision? Is it the maximum length in digits of a field, or is there more to it? What about a "field's scale", what is it and how does it affect a field's value handling? Thank you very much, Dave
-
Hello, I have been trying to develop an automatic way of programmatically accessing datasources and performing some predefined(-supported) processing on them. The question I would like to ask you people has to do with numeric fields. What exactly is precision? Is it the maximum length in digits of a field, or is there more to it? What about a "field's scale", what is it and how does it affect a field's value handling? Thank you very much, Dave
According to SQL BOL:
Precision is the number of digits in a number. Scale is the number of digits to the right of the decimal point in a number. For example, the number 123.45 has a precision of 5 and a scale of 2.
http://msdn.microsoft.com/library/en-us/tsqlref/ts_da-db_8rc5.asp[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer