Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
annas
Starting Member
36 Posts |
Posted - 2008-04-04 : 03:30:27
|
Hai...Hopefully ur guys can help me. I declare data type as float in price table. So the problem here is, whenever i enter a float number and move to the second row to enter a new number. The first number in the first row will automatically change to integer, without no reason. For example "2.3" will become "25".Is there any configuration that need to do. |
|
annas
Starting Member
36 Posts |
Posted - 2008-04-04 : 05:03:09
|
Can anyone help me pls |
 |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-04-04 : 06:25:41
|
quote: Originally posted by annas Hai...Hopefully ur guys can help me. I declare data type as float in price table. So the problem here is, whenever i enter a float number and move to the second row to enter a new number. The first number in the first row will automatically change to integer, without no reason. For example "2.3" will become "25".Is there any configuration that need to do.
How are you entering values to table?Use query analyser and use insert queryMadhivananFailing to plan is Planning to fail |
 |
|
annas
Starting Member
36 Posts |
Posted - 2008-04-04 : 08:12:18
|
i inserting direct to the table. Means i key in into the row |
 |
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-04-04 : 08:19:34
|
Try doing it through query from management studioHarsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2008-04-04 : 09:04:45
|
And you hould really stay away from the float datatype. Go with decimal instead...--Lumbago"SELECT Rum, Coke, Lime, Ice FROM bar WHERE ClosingTime = 'Late' AND FemaleMaleRatio > 4" |
 |
|
annas
Starting Member
36 Posts |
Posted - 2008-04-04 : 11:32:27
|
I am query from management studio. but i dunno why it turn this way.Oh yes Lumbaqo, i want to save a price and normally a point always included.and i did try change the data type into a decimal, but the result is the same. |
 |
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-04-04 : 11:42:20
|
Can you post table structure and what query you used to insert data?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-05 : 22:18:32
|
Tried insert value with insert statement in query window? |
 |
|
|
|
|