By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,378 Members | 1,435 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,378 IT Pros & Developers. It's quick & easy.

insert actuall value in sqlserver

P: 81
How to insert and get actuall value in sqlserver
Iam inserting a value of 3.10 using datatype as float but it is inserting as 3.1 how it posible is there any datatype to insert actuall value?
May 20 '08 #1
Share this Question
Share on Google+
2 Replies


deepuv04
Expert 100+
P: 227
How to insert and get actuall value in sqlserver
Iam inserting a value of 3.10 using datatype as float but it is inserting as 3.1 how it posible is there any datatype to insert actuall value?
hi,
there is nothing much difference in storing values like that, if you want to store as is change the column data type to decimal with two precisions, or
if you want to retrieve data in that fashion use convert or cast column value to decimal with 2 precisions

thanks
May 20 '08 #2

Delerna
Expert 100+
P: 1,134
This question is posted twice ?????
here
May 21 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.