 |  |  |  |  |  |  |  |
Max value in a decimal field
Thread Solved |
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?
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?
•
•
Join Date: Apr 2008
Posts: 296
Reputation: 
Solved Threads: 42
Posting Whiz in Training
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
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
Information is moving—you know, nightly news is one way, of course, but it's also moving through the blogosphere and through the Internets. I promise you I will listen to what has been said here, even though I wasn't here. Ann and I will carry out this equivocal message to the world. I'm the master of low expectations.
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.
•
•
Join Date: Apr 2008
Posts: 296
Reputation:
Solved Threads: 42
Posting Whiz in Training
amongst other things, it depends on precision...
Information is moving—you know, nightly news is one way, of course, but it's also moving through the blogosphere and through the Internets. I promise you I will listen to what has been said here, even though I wasn't here. Ann and I will carry out this equivocal message to the world. I'm the master of low expectations.
 |
Similar Threads
Other Threads in the MS SQL Forum
- Previous Thread: View Help and calculations
- Next Thread: How to remove duplicate records
Views: 2978 | Replies: 4
| Thread Tools | Search this Thread |
Latest MS SQL Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for MS SQL
"last 2005 access age auto autogrowth business comparing comparison. count csharp cursor data database dataset dateadd datediff datepart dates day" dbsize deadlock difference exploit fill function getdate hack helpwithhomework install join joins limit live maximum money ms mssql mssql2005 multiple multithreading mysql news null number partitioning password position query reporting result rules security select server services sets single source sql sql-injection sqlserver subtype sum supertype tables tsql unicode-sql update view weekday
