Is there any difference between DECIMAL and NUMERIC in SQL Server?

sql-server sqldatatypes
Dhanapal picture Dhanapal · Apr 17, 2009 · Viewed 128k times · Source

Is there any difference between DECIMAL and NUMERIC data types in SQL Server?

When should I use DECIMAL and when NUMERIC?

Answer

Guffa picture Guffa · Apr 17, 2009

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

MSDN: decimal and numeric

Related questions

How do you create a yes/no boolean field in SQL server?

What is the best practice for creating a yes/no i.e. Boolean field when converting from an access database or in general?

Read More
SQL Server Text type vs. varchar data type

I have variable length character data and want to store in SQL Server (2005) database. I want to learn some best practices about how to choose TEXT SQL type or choose VARCHAR SQL type, pros and cons in performance/footprint/function.

Read More
How to display two digits after decimal point in SQL Server

I have table which has a column of float data type in SQL Server I want to return my float datatype column value with 2 decimal places. for ex: if i insert 12.3,it should return 12.30 if i insert 12,it should return 12.00

Read More