I'm curious as to whether or not there is a real difference between the
money datatype and something like
decimal(19,4) (which is what money uses internally, I believe).
I'm aware that
money is specific to SQL Server. I want to know if there is a compelling reason to choose one over the other; most SQL Server samples (e.g. the AdventureWorks database) use
money and not
decimal for things like price information.
Should I just continue to use the money datatype, or is there a benefit to using decimal instead? Money is fewer characters to type, but that's not a valid reason :)