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?
Jump to PostHi,
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)) …
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
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.
amongst other things, it depends on precision...
As I said in my 1st message; also in Enterprise Manager I see Precision is set to 7 and Scale is set to 2.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.