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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Cannot save float number

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]

Go to Top of Page

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 in
2.99 and press enter it will change to this kind of number 299,0000.

i dunno why. Can u help me...

Thank U
Go to Top of Page

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]

Go to Top of Page

mayoorsubbu
Yak Posting Veteran

95 Posts

Posted - 2008-03-21 : 00:13:56
Annas,
create table #temp (name varchar(7), age float(4))
go
insert into #temp values ('xyz', 2.99)
Select * from #temp
go
The result is as expected
xyz, 2.99
Check the datatype in your table
Go to Top of Page
   

- Advertisement -