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-03-16 : 08:48:50
|
Haii..I declare data type as float. But when i enter a float number into the row it turn into decimal.Can anyone explain and help me |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-03-16 : 08:54:32
|
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=99131. Empty thread. You may delete it to avoid confusion.where did you enter the floating point number ? What do you mean "it turn into decimal" ? KH[spoiler]Time is always against us[/spoiler] |
 |
|
annas
Starting Member
36 Posts |
Posted - 2008-03-16 : 09:17:46
|
I enter in the column table itself in sql server. For Example if i key in2.99 and press enter it will change to this kind of number 299,0000.i dunno why. Can u help me...Thank U |
 |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-03-16 : 09:27:13
|
Are you using Enterprise Manager to input the value ? Where did you see the number changed ?Do you have any trigger on the table ? KH[spoiler]Time is always against us[/spoiler] |
 |
|
mayoorsubbu
Yak Posting Veteran
95 Posts |
Posted - 2008-03-21 : 00:13:56
|
Annas,create table #temp (name varchar(7), age float(4))goinsert into #temp values ('xyz', 2.99)Select * from #tempgoThe result is as expectedxyz, 2.99Check the datatype in your table |
 |
|
|
|
|