However, there are still some instances when MONEY is useful and appropriate. That's decent advice, since the DECIMAL data type doesn't come with data inaccuracy problems, and the DECIMAL data type can do everything the MONEY data type can. Given these general opinions, it's tempting to ditch the MONEY data type completely and use the DECIMAL data type instead. It's better to use the DECIMAL data type.' 'The MONEY data type could result in unintentional loss of precision from rounding errors.'The MONEY data type is bad and should never be used.'.Ask a few people whether to use it and they'll probably say: The MONEY data type in SQL Server gets a bad rap. MySQL, IBM DB2, H2, database, Postgres, Sqlite, MS SQL], and more. MySQL, Sybase ASE, Informix, Apache Derby, Mimer SQL, IBM DB2, H2, Oracle, Vertica, Postgres, Sqlite, MS SQL, Firebird, Ingres, Cache DB, and more. MS Access, MS Excel, IBM DB2, Foxpro, Firebird, InterBaseĪccess, Apache Derby, Firebird, HSQLDB, H2 (DBMS), IBM DB2, Informix, Ingres, InterBase, Microsoft SQL Server, Mimer SQL, Oracle, SAPDB, Sybase, any JDBC compliant data source.ĭB2, Sybase ( ASE/ ASA), MS Access, Firebird InterBase, Sybase SQL Anywhere, Firebird, NexusDB MongoDB, SQL Server, SQL Azure, Oracle, MySQL, PostgreSQL, DB2, Informix, Ingres (database), Firebird, SQLite, EffiProz, XML File, ODBC, OleDb, MS Access Netezza

IBM DB2 iSeries, DB2 LUW, IBM DB2 z/OS, Netezza, Sybase ASE, Sybase Anywhere, Sybase (IQ), Teradata, Aster Data Systems (nCluster), Informix, Apache DerbyĭB2 - All versions zOs and UDB, Any DB with an ODBC Driverįirebird, IBM DB2, Interbase, Amazon SimpleDB, Sybase, Hsqldb, Apache derby, KDB (database) SAP, Firebird, Advantage Database, MS Access, MS Excel 4 Features - visual design and reverse engineering.

Razorsql money type