RSS Forums RSS
Please support our MS SQL advertiser: Programming Forums

Max value in a decimal field

•
•
Join Date: Jul 2008
Posts: 11
Reputation: stockton is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 0
stockton stockton is offline Offline
Newbie Poster

Max value in a decimal field

  #1  
Jul 1st, 2008
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?
AddThis Social Bookmark Button
Reply With Quote  
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 11:38 pm.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC