Can anyone please explain the difference between the datatypes decimal(1, 1) and numeric (1, 1) in SQL with an example?

Question

1.00/5 (1 vote)

See more:

Please explain the datatype Numeric(1,1) with example in SQL Database

What I have tried:

I am confused!! Please explain with an example

Posted 13-Oct-18 0:15am

NagaNimesh 11474558

Updated 13-Oct-18 0:23am

Add a Solution

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 · Accepted Answer · 2018-10-13T00:23:00

Solution 1

There is no difference, NUMERIC and DECIMAL are synonyms: decimal and numeric (Transact-SQL) | Microsoft Docs[^]

Posted 13-Oct-18 0:23am

OriginalGriff

Comments

NagaNimesh 11474558 13-Oct-18 6:27am

Thanks for the reply.

Can you tell me the example for NUMERIC(1,1) datatype

OriginalGriff 13-Oct-18 6:42am

Did you bother to read what I said, and follow the link?

NagaNimesh 11474558 13-Oct-18 6:31am

I tried to insert 0.1 to 0.9 but no luck

NagaNimesh 11474558 13-Oct-18 6:49am

I have already gone through that link you shared and I tried to insert the 0.1 value to NUMERIC(1,1) I am confused that is reason I posted here could you please tell me one example for NUMERIC(1,1)

OriginalGriff 13-Oct-18 6:54am

And how do you expect me to know what you did that is different from the examples in the link code without being able to see your code?

NagaNimesh 11474558 13-Oct-18 7:02am

We have created a table in SQL Server and the column datatype we declared as NUMERIC(1,1) and we tried to insert a value to that column from GUI,Microsoft SQL Server management studio.
But unable to insert the value like 0.1 to 0.9.

OriginalGriff 13-Oct-18 7:11am

At the risk of repeating myself:
"And how do you expect me to know what you did that is different from the examples in the link code without being able to see your code?"