# difference between numeric(18,0) and decimal(18,0) RSS

## 5 replies

Last post Oct 04, 2012 05:23 AM by sureshkumar.gundala

Member

28 Points

10 Posts

### difference between numeric(18,0) and decimal(18,0)

Hello friends,

I want to know about difference between numeric(18,0) and decimal(18,0)

Thanks

Abhimanyu Rawat

Participant

751 Points

210 Posts

### Re: difference between numeric(18,0) and decimal(18,0)

They are the same. Numeric is functionally equivalent to decimal.

• Edited by graciax8 on Sep 21, 2012 04:43 AM

Participant

1265 Points

247 Posts

### Re: difference between numeric(18,0) and decimal(18,0)

Hi,

use the float or real data types only if the precision provided by decimal is insufficient so generally because the precision provided by decimal is [10E38 ~ 38 digits] if your number can fit in it, do not look at float.

more useful information extracted from the cited book

• numeric(precision, scale) = decimal(precision, scale) - Exact Numeric Data Types
• real = float(24) - Approximate Numeric Data Types
• All exact numeric types always produce the same result, regardless of which kind of processor architecture is being used or the magnitude of the numbers
• The parameter supplied to the float data type defines the number of bits that are used to store the mantissa of the floating point num

Refer teh following site for clear description

http://blog.sqlauthority.com/2007/08/29/sql-server-difference-and-explanation-among-decimal-float-and-numeric/

Hopes Helps U...

Participant

887 Points

798 Posts

### Re: difference between numeric(18,0) and decimal(18,0)

طحہ زبیر احمد
Taha Zubair Ahmed
http://www.tahazubair.blogspot.com

Contributor

3988 Points

760 Posts

### Re: difference between numeric(18,0) and decimal(18,0)

Service Of Mankind Is True Worship Of God..

Contributor

2143 Points

504 Posts