•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 391,584 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,650 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 542 | Replies: 4 | Solved
 |
•
•
Join Date: Jul 2008
Posts: 6
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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: 295
Reputation:
Rep Power: 1
Solved Threads: 41
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.
•
•
Join Date: Jul 2008
Posts: 6
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
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: 295
Reputation:
Rep Power: 1
Solved Threads: 41
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.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Linear Mode
Similar Threads
Other Threads in the MS SQL Forum
- Previous Thread: View Help and calculations
- Next Thread: retrieving username and password
