What datatype we can use to store decimal values in sql server 2005

Question

5.00/5 (1 vote)

See more:

SQL-Server-2005

Hi,

In one of my database table i am used decimal datatype to store weights and distence.

I specified datatype and range like bellow:

decimal(18,3)

i want to store three degits after decimal point for example if user enters 8393892.89828 for that i want store like 8393892.898.But in my tabel data is storing like 8393892.000 only.

Please anybody explain me what my be the reson and how to solve this one.

Thanks
Uday

Posted 23-Oct-11 23:25pm

udaysimha

Add a Solution

Comments

Prerak Patel 24-Oct-11 5:35am

How do you store? Share some code.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2011-10-23T23:36:00

Solution 1

When I try it in a simple test, it works fine:

SQL

INSERT into myTable (dist) VALUES (123.456 ) , ( 8393892.89828)

Where "dist" is decimal(18,3)
I get the values:

123.456
8393892.898

So, it must be your code to insert it - what are you doing to insert these values?

Posted 23-Oct-11 23:36pm

OriginalGriff