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
abhimanyuraw...
Member
28 Points
10 Posts
difference between numeric(18,0) and decimal(18,0)
Sep 21, 2012 04:34 AM|LINK
Hello friends,
I want to know about difference between numeric(18,0) and decimal(18,0)
Thanks
Abhimanyu Rawat
graciax8
Participant
751 Points
210 Posts
Re: difference between numeric(18,0) and decimal(18,0)
Sep 21, 2012 04:42 AM|LINK
They are the same. Numeric is functionally equivalent to decimal.
MSDN : http://msdn.microsoft.com/en-us/library/aa258832%28SQL.80%29.aspx
mycodepad.blogspot.com || TUMBLR
maheswari.bo...
Participant
1265 Points
247 Posts
Re: difference between numeric(18,0) and decimal(18,0)
Sep 21, 2012 07:31 AM|LINK
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
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...
tahazubairah...
Participant
887 Points
798 Posts
Re: difference between numeric(18,0) and decimal(18,0)
Sep 24, 2012 06:53 PM|LINK
In C# No difference both of them are same
http://stackoverflow.com/questions/1056323/difference-between-numeric-float-and-decimal-in-sql-server
Taha Zubair Ahmed
http://www.tahazubair.blogspot.com
pradeep shar...
Contributor
3988 Points
760 Posts
Re: difference between numeric(18,0) and decimal(18,0)
Sep 25, 2012 05:42 AM|LINK
http://msdn.microsoft.com/en-us/library/364x0z75(v=vs.71).aspx
sureshkumar....
Contributor
2143 Points
504 Posts
Re: difference between numeric(18,0) and decimal(18,0)
Oct 04, 2012 05:23 AM|LINK
H,
There is no difference between numeric and decimal. Both are same
Best Regards,
Suresh Kumar Gundala