Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Decimal Fields

Status
Not open for further replies.
WelshyWizard

WelshyWizard

IS-IT--Management
Apr 23, 2006
89
GB
Hi all,

I've created a table within SQL Server 2000 and have a decimal (9) field called FACTOR. When I type a value in this field, say 1.4, the value gets changed to a 1. Why is this and how can I stop this happening?!

Cheers

Today is the tomorrow you worried about yesterday - and all is well.....
 
Sort by date Sort by votes
Sorry... I was being stupid! I had the scale set to 0!!!

Today is the tomorrow you worried about yesterday - and all is well.....
 
Upvote 0 Downvote
That would certainly do it. @=)

Glad you figured it out.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

1DMF
  • Locked
  • Question
Adding fields when mandatory is required? 2
Replies
5
Views
78
1DMF
1DMF
LucieLastic
  • Locked
  • Question
Importing from Excel - Nulls for blank varchar fields & Ref Integrity
Replies
1
Views
60
drlex
drlex
pandatime
  • Locked
  • Question
Import to varchar fields - ok? 1
Replies
5
Views
84
pandatime
pandatime
Zen216
  • Locked
  • Question
Export tables (description and fields) 1
Replies
4
Views
48
roseusa
roseusa
Auguy
  • Locked
  • Question
Change SQL 2000 TrimTrailingBlanks setting for Selected Fields
Replies
0
Views
27
Auguy
Auguy

Part and Inventory Search

Sponsor

Back
Top