What is the difference between numeric and decimal in sybase

Create a free Team What is Teams? Learn more. Ask Question. Asked 7 years, 1 month ago. Active 2 years, 10 months ago. Viewed 58k times. However, the MSDN documentation describes the relationship between the two as this: numeric is functionally equivalent to decimal. Improve this question. KutuluMike KutuluMike 1, 2 2 gold badges 14 14 silver badges 13 13 bronze badges. Add a comment. Active Oldest Votes.

Assigning one to the other is technically a "conversion"? Go ahead and try this test, too data and indexes.

Improve this answer. Glorfindel 2, 2 2 gold badges 13 13 silver badges 24 24 bronze badges. Aaron Bertrand Aaron Bertrand k 25 25 gold badges silver badges bronze badges.

I know this is an old answer but I just found a case where thinking that numeric and decimal are synonyms caused SQL Server to raise an error. Just thought I should leave a comment here in case someone else might benefit from it. AaronBertrand I voted up for your answer because it is helpful. In my Comprehensive Database Performance Health Check , we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future. Estimated Execution Plan. Leave new Rebecca. Nice blog. But I am getting different values.. Pinal Dave. I understand the need for redundancy but not for datatypes. My guess is that numeric came first, and when the SQL standard came around, which uses the name decimal for the same kind of type, SQL Server adopted it as a synonym. Else fight the flow Thanks for the article that was pretty good.

My favorite line was: "The moron that declared columns to be FLOAT in a commercial system is probably a C programmer who does not understand rounding errors". Subscribe to SQLTeam.

Home Weblogs Forums.