Menu
Is it money, float, real, decimal, _________ ?
309
The decimal(x,y) SQL Server type is for when you want exact decimal numbers rather than floating point (which can be approximations). This is in contrast to the C# "decimal" data type, which is more like a 128-bit floating point number. MSSQL's float type is equivalent to the 64-bit double type in . NET.
Fixed-point data types are perfect for number schemas that don't change like currency where you know you'll always have two digits to the right of the decimal point. Two fixed-point data types exist in SQL called decimal (DEC) and numeric (NUM).
Answer to this and all mapping of types can be found here.
SQL-CLR Type Mapping
Chart, stolen from that page:
Updated 1/7/2013 - there's a more recent version, .not so colorful here: SQL Server Data Type Mappings
61
That would be float.
See Mapping CLR Parameter Data.
34
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
