I want to take USD and EUR Rates from TCMB page. Im using this first of all. Im using this for creating table. Im using this for parse XML file but I couldn’t parse correctly. I want to take only Date(as Tarih), DolarForexBuying,EuroForexBuying rates. And Im using this code for adding rates to my table. Answer Microsoft proprietary OPENXML and
How do I utilize a WHERE clause with a MONEY data type?
So to keep it simple, I’m working on a problem that requires a simple case of utilizing the WHERE clause to bring back records that have the field (we’ll call it ‘tax’) equal to $0.00 So as per usual, I thought I could do: WHERE tax = 0; But I keep getting an error. And I’m pretty sure it’s because
In a currency exchange rate what is the maximum number of decimal places used?
I need to store currency exchange rate data in the SQL 2008 database. I would like to keep rate as a decimal data type in the database. One thing I am not sure about, is how many decimal places to give (e.g. decimal(18, ?)). Since, I will be using this service as a source: http://openexchangerates.org/latest.json. There, it seems that the
How to use money data type in Java, SQL, ORM
What are best practises in using money data type in Java application? Money should be in double variable? What about rounding, currencies and so on. Are special libraries for this? And what about ORM and SQL in most popular databases. As I know not in all SQL engines is Money data type. In that case NUMERIC(15,2), DECIMAL(15,2) or REAL data