What is the best way to store a money value in the database?

c# sql tsql currency
ntombela picture ntombela · Mar 6, 2009 · Viewed 22.8k times · Source

I need to store a couple of money related fields in the database but I'm not sure which data type to use between money and decimal.

Answer

Rad picture Rad · Mar 6, 2009

Decimal and money ought to be pretty reliable. What i can assure you (from painful personal experience from inherited applications) is DO NOT use float!

Related questions

What represents a double in sql server?

I have a couple of properties in C# which are double and I want to store these in a table in SQL Server, but noticed there is no double type, so what is best to use, decimal or float? This …

Read More
Generate class from database table

How can I generate a class from a SQL Server table object? I'm not talking about using some ORM. I just need to create the entities (simple class). Something like: public class Person { public string Name { get;set; } public string …

Read More
SQL error: Incorrect syntax near the keyword 'User'

I am using SQL to insert data to SQL Database file using C# as follows. String cs = System.Configuration.ConfigurationManager.ConnectionStrings["connection1"].ConnectionString; SqlConnection conn = new SqlConnection(cs); String sql = "INSERT INTO User (login, password, status) " + "VALUES (@login, @password, @status)"; …

Read More