Money, Decimal or Numeric for Currency Columns
sql, sql-server
Solution
First of all, Decimal and Numeric have the same functionality (MSDN info about it)
To answer the new question money VS decimal, there is already a Stackoverflow question about it: Should you choose the MONEY or DECIMAL(x,y) datatypes in SQL Server? - the short answer was:
Never ever should you use money it is not precise and it is pure garbage, always use decimal/numeric
by SQLMenace
Problem
I am creating a SQL table to hold transactions: ``` create table dbo.TRANSACTIONS ( Id int identity not null, Amount money not null ); ``` For currency (I am using euros) should I use money, decimal, or numeric? I have seen the three being applied to currency columns so I am not sure anymore. Money would be the obvious choice ... But I have seen decimal and numeric to. By the way, I am using SQL Server 2012. Thank You