Decimal Vs Numeric (Difference Between Decimal and Numeric)

In this blog you will learn the difference between Decimal and Numeric.

There is no difference between Decimal and Numeric.Both datatypes perform same on the assigned column.

EX 1:

IFOBJECT_ID('dbo.Explanation') > 0
DROPTABLEdbo.Explanation
CREATETABLEdbo.Explanation
(
    Decimalcolumndecimal(5, 2), NumericColumnnumeric(5, 2)

);

GO
INSERTINTOdbo.ExplanationVALUES(123, 123);
GO
SELECTDecimalcolumn, NumericColumn
FROMdbo.Explanation;

EX 2:

IFOBJECT_ID('dbo.Explanation') > 0
DROPTABLEdbo.Explanation
CREATETABLEdbo.Explanation(
    Decimalcolumndecimal(10, 4), NumericColumnnumeric(10, 4)

);

GO
INSERTINTOdbo.ExplanationVALUES(12345.67, 12345.67);
GO
SELECTDecimalcolumn, NumericColumn
FROMdbo.Explanation;