0

Not being a SQL programmer please forgive the following but I need to know.

I have a MSSQL database with a table containing a row defined as
Column Name Data Type Length
Turnover decimal 5
also in Enterprise Manager I see Precision is set to 7 and Scale is set to 2.

Is it possibly that the max value could be limited to 9999,99 and if so what needs altering to allow up to 1000000,00?

2
Contributors
4
Replies
5
Views
9 Years
Discussion Span
Last Post by stockton
0

Hi,

So you have a table consisting of 6 columns: Column Name Data Type Length
Turnover where the latter should be of decimal data type???

What do you mean by "that the max value could be limited to 9999,99" ? Should output format be restricted to 9999.99 (decimal(8,2)) or the value of turnover itself must not exceed 9999.99 what would be a matter of constraints defined in create table statement?

krs,
tesu

0

No there are 3 colums, Name Type & length and the question is what is the maximum value that a decimal with length of 5 can hold.

0

As I said in my 1st message; also in Enterprise Manager I see Precision is set to 7 and Scale is set to 2.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.